UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support help :( I can't import using myphpadmin

Can someone please tell me how can import my database onto a new server? I got a backup, its too big 14MB .gz

So I exported the tables in groups. I can't get the w3t_posts can this be done from the file I upload onto the server and use a sql query of some sort?

Thanks!

I got all 38 table on, I just need to get the blasted w3t_Posts on and its 39 and I am done.

Do you have access to MySQL through SSH? If so you can:
mysql -h localhost -uusername -ppassword databasename < sqldump.sql

Be sure that you don't remove the -u in front of username or the -p in front of password; also be sure to update all sections (username, password, databasename and the name of your sql file)

I have been using Big Dump to import about 100 MB from UBB Threads when moving to another server.

You can find the free script here.

Hey thanks! That does work cool.

All my forum works for reading, but when I post I get errors <img src="https://www.ubbcentral.com/boards/images/graemlins/frown.gif" alt="" />

Can someone run me through the exact settings in myphpadmin to dump the database so its a proper copy, I know that has to be my problem.

Thanks!

In PHPMyAdmin all you do is browse to the database, select export, click "select all" and "save as file" (I like to choose zip as well) then download the file...

What I like to do is make my sql dumps (large ones anyhow) through the SQL command line (through SSH):
mysqldump -uuser -ppassword database_name > dump_file.sql