how to restore mysql into db at 1and1.com?

[WebUser]

anyone here knows how to restore (import) a file a.sql to 1and1.com mysql database ? I tried the user, pass they give in the admin control panel, but that one doesn't work.

[darkcurves]

What about ask them? I am sure they have a forum rite?

[srikat]

Originally posted by WebUser
anyone here knows how to restore (import) a file a.sql to 1and1.com mysql database ? I tried the user, pass they give in the admin control panel, but that one doesn't work.

http://s88567960.onlinehome.us/forums/index.php?showtopic=5

[WebUser]

that one doesn't work with big file . phpMyAdmin just works for small files.

[srikat]

How many lines is your .sql file? I've found that via phpmyadmin (not at 1and1, but another host) you can feed around 1800 lines at a time, not sure if that number differs from host to host.

There might be a better way of doing this...

[aldee]

Posted this in a different forum already - try the following when logged in via SSH:

mysql --host=yourdbserver --password=XYZ --user=yourusername yourdatabasename < dump.sql


For exporting you might try:

mysqldump --host=yourdbserver --password=XYZ --user=yourusername yourdatabasename > dump.sql