Copy SQL DB to New Sever

Discussion in 'Server Operation' started by E.L. Hibee, Jun 20, 2006.

  1. E.L. Hibee

    E.L. Hibee New Member


    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?

  2. sjau

    sjau Local Meanie Moderator

    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:
  3. falko

    falko Super Moderator Howtoforge Staff

    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).
  4. E.L. Hibee

    E.L. Hibee New Member

    Thanks for the reply.

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

  5. sjau

    sjau Local Meanie Moderator

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

Share This Page