Web Hosting Talk : Web Hosting Main Forums : Web Hosting : Moving MYSQL DAtabases

[fpdesignco]

Hello,

I have two 10 megabyte databases I need to move, The problem is if I where to move them by phpmyadmin or a program like that It would time out. So How would I go about this?

[BSDSpot]

Are you trying to move the databases to another machine ? Why not export the databases from phpmyadmin, then tar and gzip them. Then send them to the other machine via ftp. Sql files are text so they usually compress well.

[fpdesignco]

I could do that but they would still have to be imported... thats where the problem occurs

[BSDSpot]

Sorry, don't have enough posts yet to send you a pm. Assuming you've transferred the sql files to the new server, and that it has phpmyadmin running, can you excute the sql to recreate the databases ?

[fpdesignco]

No,

thats the whole problem it will time out, databases are to large

[SimonP1878]

open the exported file in a text editor, and copy and paste small parts of it into your SQL query box on PHPMyAdmin

takes a good hour or so, and it's boring as hell - but it gets the job done!!

[tree-host]

You could try asking your host to do it, as they may be able to import it from the command line for you, which should prevent the time out.