omg wtf..... stupid posts query
 

how come when i backup the posts query from my boards it wont let me upload it in my phpmyadmin. its a big file and i cant just keep uploading and trying again.

when i upload it it says No SQL Query!

If it is a very big file it won't work via phpMyAdmin as it will just time out eventually anyway as it can't execute within the required time.

doh, it is kinda big.
is there anyway i can transfer it??

Follow the instructions here: http://www.vbulletin.com/forum/showt...threadid=43873

This thread at vB.com has details on how to import via SSH.

how is this gonna help me?

anyone know what to do???
comon there has to be someone that can help me

It tells you **exactly** what to do, if thats not help well... I don't think you have much of a chance.

ok, i have no clue what they are talking about.
1st of all what is WGET,
2nd what is and where do i enter "mysql -u USERNAME -p EMPTYNEWDATABASENAME <sqlbackup/041002.sql"
3rd do i have to buy this vbulletinhosting thingy

you can call me a newbie but all i know about mysql and php is how to instal vb and install hack :-/

ok, i was at the vb.com forums asking the same question, the told em how to do it but i need someone to translate this into newbie form:

Step One - Backup current database:

Telnet into your system (we'll call it machine1)
from the root directory, type
mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql
this should only take about than 30 seconds to a few minutes, depending on your database size
when it is completed, it will bring you back to the prompt
verify that you have a dump.sql in the /path/to area you specified
Step Two - Transfer to new server

telnet into machine1, and from the command prompt type the following:
cd /path/to/yourbackupdirectory
Then type
ftp MACHINE2
Replace MACHINE2 with the host name (eg. www.example.com ) or IP address (eg. 192.168.0.0 ) of your new server. This should open a connection and ask for your username/password, then it should say ftp>
Type the following, hitting enter after each line:
bin
cd /path/to/newdirectory
put dump.sql
It should take between 20 seconds and a few minutes depending on the size of the file. Now type:
close
quit
verify dump.sql is in the /path/to/new area on the new server.
Step Three - Restore to new server

telnet into machine2
create a database on the mysql if necessary (ask your server admin for help with this as it varies from machine to machine)
at the prompt type
mysql -uUSERNAME -p newdbname < /path/to/dump.sql
this takes a couple of minutes depending on your database size, but you can track the progress either by FTP (checking the /mysql/data/newdbname and see the files appearing) or by phpMyAdmin (you should see the files appearing there)
when it is completed, it will bring you back to the prompt
Step Four - Bringing it back online

Go into your config.php and change the database name to the database name you created in Step 3, if necessary.
upload config.php
Go into your admin/index.php and then click on "options" and change the URL (if necessary) and verify the options and click "submit"

Just use MySqlFront :)