Help me work with PHPMyAdmin on MySQL 5.x

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
sj1983msh
Forum Newbie
Posts: 15
Joined: Thu Feb 28, 2008 12:01 pm

Help me work with PHPMyAdmin on MySQL 5.x

Post 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.
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

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

Post 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.
sj1983msh
Forum Newbie
Posts: 15
Joined: Thu Feb 28, 2008 12:01 pm

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

Post 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.
Post Reply