Copy SQL DB to New Sever

Hi

I have just setup SUSE 10.1 server with ISPConfig and instlled the add on PHPMyAdmin-2.6.4-pl3.

I have a SQL database on my current server (hosted by an ISP) and I can export this database using phpmyadmin but I cannot figure out how to import it into PHPMyAdmin-2.6.4-pl3 as the option for import is not there.

Can anybody help?

Thanks

 

The most simple way to copy a db from one server to another is:

1.) shutdown mysqld on both servers
2.) just copy the files from one to the other server
(in my case path would be :/var/lib/mysql/DBNAME --> just copy the whole folder and set afterwards the right owner and permissions)
3.) restart both mysqld servers

That is just quick and dirty. A more appropriate solution can be found here:
http://www.howtoforge.com/faq/category6.html

 

If you want to use phpMyAdmin to import your dump, you must go to the appropriate database and then click on the tab "SQL". Then you copy the contents of your SQL dump into the textarea and click on "Go". But this might not work if your dump is too large (e.g. bigger than 2 MB).

 

Thanks for the reply.

Worked it out more or less what Falko said, slowly getting the hang of this stuff.

Cheers

 

I would use command line... it's way more confortable ^^