Database backup...

richie

Hi,

I would appreciate some help backing up a database between two different sites.

I have a db on a windows machine, size is about 50MB, and need to copy it to a unix machine on another domain.

I tried mysqldump, but it wouldn't do it. Here is the command I used:

c:\mysql\bin > mysqldump --opt -u userName -pPassword DBname | mysql -u remoteUser -pRemotePass --host=RemoteDomain.tld -C DBname

Another method I tried was:

c:\mysql\bin > mysqldump -u Username -pPassword dbName > c:\windows\desktop\1.txt

That worked, and I have a 50mb file sitting on my desktop. However, when I try to use phpmyadmin to execute the commands (create table, insert into) in the text file, I get "page cannot be displayed" error.

Any ideas?

Thankx.

iNFERiON

yeah, phpMyAdmin can not handle such large files. What you should do is when you copied the database to your unix machine to use this command

mysqld --user=username --pass=password < backupfile.sql

richie

Wouldn't that require shell access to the unix machine?

mikeatrpi

mysql -u remoteUser -P -h hostname.com < file.sql

You can connect to the remote host using your local mysql binary. The options and changes you make to the above command and SQL file are up to you. For instance, specifying a database.

nemonoman

You can try the exec command (I think passthrough would also work. My PHP for a dump and load is:

exec("mysqldump -h myhost.biz -umyusername -pmypassword --opt mydatabasename> myfile.sql") ;
echo("mysql -umyusername -pmypassword mydatabasename< $myfile.sql");