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.
Help me work with PHPMyAdmin on MySQL 5.x
Moderator: General Moderators
- 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
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.
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
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.
Sincerey Yours
Saman J.