omg wtf..... stupid posts query

[DarkDraco07]

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!

[NTLDR]

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.

[DarkDraco07]

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

[NTLDR]

Follow the instructions here: http://www.vbulletin.com/forum/showthread.php?threadid=43873

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

[DarkDraco07]

how is this gonna help me?

[DarkDraco07]

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

[NTLDR]

Originally posted by DarkDraco07
how is this gonna help me?

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

[DarkDraco07]

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 :-/

[DarkDraco07]

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"

[Hwulex]

Just use MySqlFront (www.mysqlfront.de) :)

[DarkDraco07]

ok, i downloaded and installed it, when i connected with it i got this error:

1130 - Host 'dsc09.waf-dc-0-99.rasserver.net' is not allowed to connect to this MySQL server

[DarkDraco07]

/me grows a beard while waiting for help

[DarkDraco07]

can someone please explain it?

[Admin]

DarkDraco the image in your signature is too large, please remove it or we will.

[[D]Vincent]

I need help with this also kind of I just need to know how to backup my database and upload the thing. The manual didn't help because I don't know what the hell telnet is =\

[N9ne]

If you have a shared server, you may not have telnet, infact most don't but I got lucky :D

[NTLDR]

You probably (in fact almost definatly) won't have telent access as its unsecure. You may probably have SSH access. Nakkid (aka TECK) posted a tutorial in the hints and tips bit on how to backup your database and how to restore it and gives details of how to do it via SSH.

[DarkDraco07]

Firefly - ok, you need to install the sig size hack on this forum

DVince- I feel you

NTLDR - Can you link us