How do I go about doing this, I tried the way vbulletin.com show but I can't get it working, is there anything I'm missing? A step by step guide would be usefull.

What is the problem you're encountering? Maybe someone here can tell you how to fix it....

Do you mean dumping the database then restoring it?

If you mean, you are having problem with back up your database, then get installed the phpmyadmin, and dump your data to your local computer. this is the easiest way. but If you have SSH or telnet access, it can be done by using command line.

for the database not been corrupted, stop Mysql during the back up then start it.

Hi!
mysqldump and mysqlimport are the two commands used..
use man for more information. It is very easy..
Have a great day :)
regards
amar

Could someone go through the procses of doing this in telnet please, list of commands e.t.c

Hi,


You need to describe your tasks in details for somebody could help you

ie What do you mean - local transfer or between computers. How much is your db weight, and so on.
What do you want?

Regards

I'm moving one DB from my old ded server to my new ded server. I have root accsess for both of them.

Furton,

on the old ded box:

mysqldump -u db-user -p database-name > dump-file.sql

where:

db-user == database user name
database-name == the database you wish to backup (dump)
dum-file.sql == any file name

Then ftp the file to the new dedicated box. The file is just ASCII so you can gzip it first if you wish

On the new ded box:

Create the new empty database (webmin, phpmyadmin etc.)

mysql -u db-user -p database-name < dump-file.sql

That will reload the db.

Frank

I've tried to FTP to my new server, but when I enter my root pw it rejects it. What PW and User am I meant to use?

ftp may be setup to now allow root to ftp in (for security reasons). Use any id that you know.

You can also ftp from the new box and just do a "get" instead of a "put".

Frank