Loading Mysql dump

[stebut05]

Hi,

Really appreciate some help please. I am moving a database from one server to another. I have done a mysql dump to a txt file. How do i upload this txt file to create all tables and insert all data??? Thanks for all your help

Regards,

Steven

[matto]

is phpMyAdmin available? - open up db and go to "SQL", you can upload it there.
if not, is console access available? ftp up the file, go to mysql shell, connect to your db and run the export script with .FILENAME.txt.

!! this works only if you exported the database as "SQL INSERTs" (not raw data, comma-separated) !!

in all other cases, you could upload the .txt file and write a php script that reads in the data and executes inserts. (this solution is most work)

[stebut05]

Hi,

Thanks for your help. No phpadmin or shell access. Can you help me with a php script please? I have given the webhost the sqldump text file and they have uploaded it. So i just need to execute it. As i have tested webpages using the database and all the connection settings are correct, but is not recognising tables. I assume this is because i need to run a script to read and execute. Many thanks for your help

Regards,

Steven

[Doug_G]

phpMyAdmin is a php script 🙂 It's pretty easy to install on a php/mysql server. Beyond this single task, you'll want something to admin your database, and phpMyAdmin is a very good solution.