Page 1 of 1

Help me work with PHPMyAdmin on MySQL 5.x

Posted: Sun Apr 20, 2008 4:59 am
by sj1983msh
Hi everyone,

I am using NaviCat on my PC to work with MySQL 5.x, but I do not know how to work with PHPMyAdmin installed on the server which I want to import my Data-Base to it.

Tell me How I can export from NaviCat and how to Import my DB to server via PHPmyAdmin.

And also tell me, if I define triggers or Stored procedures and Function for my Data-Base on my PC, when I export it via the method you will tell me; do all of the triggers or ...... export with it? And I don't need any further modify on the server under PHPmyAdmin for triggers and....??

Please me how I can do these. Even if you don't want to tell me about the import/export, tell me the answer of my second question. I appreciate that.

Sincerely Yours
Saman J.

Re: Help me work with PHPMyAdmin on MySQL 5.x

Posted: Sun Apr 20, 2008 2:54 pm
by Kieran Huggins
http://www.reg.ca/faq/PhpMyAdminTutorial.html

You can export an SQL dump from NaviCat and then import it into phpmyadmin. You can also use the command line tools (easier than it sounds).

I don't think stored procedures are transferred in an SQL dump, you'll have to add them to the new server.

Re: Help me work with PHPMyAdmin on MySQL 5.x

Posted: Sun Apr 20, 2008 3:12 pm
by sj1983msh
thanks, but can you please tell me, where should I go (in PHPMYADMIN) on the server exactly to input stored procedures or to see the triggers I have coded for my tables?


Sincerey Yours
Saman J.