Updated (Restore Backup)

[jam583]

I updated this question because my last one was kinda confusing, but, I got a lot answered. Here is my situation. I currently have a dedicated web server on FREEBSD 4.2 It's great, but, I need to get the VB MYSQL DUMP on a new Win2k server to restore it. Here is what I've found out:

First, I must telnet into the server. Then I must type the following command:

/usr/local/plesk/mysql/bin/mysqldump -uUSERNAME -pPASSWORD DATABASENAME > /home/yourusername/dump.sql

I attempted to use the backup I got from the VB control panel, but, during a restore, it did nothing but give errors.

My first question is where will this "dump" save on my computer so I can restore? I understand all of it until > /home/yourusername/dump.sql -- What does here? The new MYSQL information?? I am physically sitting at this Win2k box. My sql is located at c:/mysql -- I've made a new database already.

Once I overcome that question my next question is as follows. I was told by Kevin (Tube Dogg THANKS!!) to do this:

1) Open MS-DOS
2) Type
cd \mysql\bin
3) Type
mysql -uUSERNAME -pPASSWORD NEWDBNAME < /path/to/dump.sql
It's probably easiest if you put this dump file in the c:\mysql\bin directory to start with, then just use dump.sql for the name/path, like so:
mysql -uUSERNAME -pPASSWORD NEWDBNAME < dump.sql
4) Wait.
5) It'll return to the prompt when done.

I totally understand that, but, I don't understand where to get this dump file from, I mean, how do I get it on MY HD to begin with. I really appreciate everyones help. Sorry to start a new thread, but, I think it will help get my question answered if I explain it better. Thanks again.

[Maddogsuk]

I have been following you previous posts and also interested in you backup and restore problem, I too be a newish to this server \ sql stuff!

First from you previous thread your using a machine that has access to MS-Dos? And you want to take the sql database from that machine and load it onto a machine running W2K?

The problem is you cant get the mysql database from the old machine?

Forgot to ask, you also have physical handson access to these servers?

[Mike Sullivan]

The > pipes the output into the filename specified after it. (Don't include the > /path/to/dump.sql and you'll see mysqldump just prints out the dump of your database).

/home/yourusername/dump.sql is the file on the server where the dump is put into. You should change this to a place where you can create files on your FreeBSD server. After you run mysqldump, go to the directory you dumped to and you should see the filename you specified (if you used /home/yourusername/dump.sql , you'd go to /home/yourusername and look for dump.sql). All you have to do is download that dump.sql file to your computer (probably easiest via FTP).

[Enny]

or use these scripts

To use this scripts copy the files from backuprestore.zip in directory with CHMOD 777 on your webserver and change in scripts HOST, USERNAME, PASSWORD, DATABASE and absolute patch to script-files.