UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support How to re-import a DB

Need some quicky help. I need to re-import my old threads 65 database, but I can't seem to do it with PhPadmin imort function because the DB file is too big. So, I want to to it as root user via SSH. Ok, so I have uploaded via FTP program my thread65.sql file. I have also created teh threads65 database (which is empty of course). At the command line, I know I can go to MySQL, then say MySQL> use threads65 to change to that database. But I can't remember for sure how to import my threads65.sql file inot the threads56 database. Do I just go to the directory the file is saved in then go to MySQL> use threads65, then at teh MySQL like just type the name of the script file (e.g., MySQL> threads.sql;

Or is there something more to it? It seems like last time I did this I did something like MySQL> databse user > file; but I'm note positive. I know this is simple, I just don't do it enough.

Any help would be appreciated.

Basil

Basically, just go into the directory where you have your threads65.sql file. At that point you'd type this:

mysql threads65 < threads65.sql -u username -p

Change username to your database username. It will then prompt you for your password, and then it will import your threads65.sql file.

In some instances MySQL will not accept the above line due to the host parameter not being utilized, I generally use:

MySQL Export: mysqldump -uusername -ppassword database_name > backup_file.sql
MySQL Import: mysql -h localhost -uusername -ppassword database_name < backup_file.sql

Thanks guys.