ok i wanting to move a message board from server a to server b

anyhow

i goto server a and
cd /usr/local/psa/mysql/bin
./mysqldump -u myusername -p databasename > databasebackup.sql

it saves it as like 3.1megs i scp it to server b and its already in the mysq/bin folder so i
cd /usr/local/psa/mysql/bin/
./mysqldump -u sameusername -p databasename < databasebackup.sql

and it scrolls a bunch of text in my console and acts like it worked but yet i load the page and nope :( shows default install of the forum.

and i named the database and database logins the same all with same pass

any help is apreicated as i can't figure out what i'm doing wrong as i have moved forums many times before with no problems.

Zac

Hy,

use the mysql command and not the mysqldump command to restore the sql file into the database.

./mysql -u sameusername -p databasename < databasebackup.sql

Greetings
O. Schlag

[root@ns bin]# ./mysql -u Name -p DBNAME < backup.sql
Enter password:
ERROR 1050 at line 11: Table 'ibf_admin_sessions' already exists
[root@ns bin]#

got it :) thanks "CJCS" i had to delete all the old tables from the new clean install to import old db :)

thanks it works