Importing existing MySQL dB...?

[rbhaydon]

Importing existing MYSQL database..?
I hope this isn't an easy question that's obvious to everyone but me...

I have an existing client running a website using PHP and a separate MYSQL databaase. I have imported all the HTML/.PHP files into a new PLESK domain, but when I looked up the chapter on setting up user databases in the PLESK 7.5 Reloaded manual, it talks about uploading the database via a "SQL script". Did I misunderstand? I guess this is not as simple as a file copy from the old server to the new one+ a few other steps...I think PLESK/PHP-MySQL is much better for people starting a database from scratch...?

Can anyone please tell me how I import an existing MySQL dB from one Linux server to a PLESK Linux server?

Very much appreciated!

Thanks,
Bruce

 

[DiLDoG]

You have to export the data fitst.

On the old server, login to phpMyAdmin select the database. click the "Export" tab. Select all tables, check "Save as file" and "Go".

Save the file somewere on your hdd.

Then on the new server
phpMyAdmin, click the "SQL" tab, enter the Location of the textfile and "Go"

that should do the trick.

 

[sieb@]

You can install PHPMYBackup in the admin folder.

http://sourceforge.net/projects/pmbackup/