I killed my boards! I have a backup but do not know how to load it

[All-Madden]

how is that done? I have SQL dump's as well as the vB backup

[Jake Bunce]

you can restore your database backup by running this command from the shell (telnet connection to your server):

mysql -uusername -p databasename < backupname.sql

replace the bold text with your info... this comes straight out of your config.php file. replace backupname.sql with the name of your backup file.

[All-Madden]

sweet...cept

Iam running windows and have no access to a box running linux. Certianly their must be anoter way, how about if I just recreate the tables? I did a backup of everything a few times and in as many ways as I could

[Jake Bunce]

the only way to restore a database backup file is through the shell.

[Steve Machol]

The command Jake gave you should work for Windows systems too.

[All-Madden]

Jake is their an alternative?

can I recreate the tables individually? my boards were running on db allmadden_org now their on all-madden-net and are updated from .6 to .9 I have 2,700 users getting pissed, I was confident I would be able to do this quickly and effectivly, however I was wrong! I do not have a linux box nor access to a telnet capable machine!

[Steve Machol]

Have you tried running the command Jake gave you? You do not need a Linux box to do this. You do need shell access though. If your host does not provide telnet or ssh access, then the best option is to ask them to restore your backup for you. It should only take them a couple of minutes.

[All-Madden]

also I cant get into my .org account

I have a license that how I got here!

Originally posted by Steve Machol
The command Jake gave you should work for Windows systems too.

[Steve Machol]

Originally posted by All-Madden
I have a license that how I got here!

Huh? No one was questioning your license. I asked you if you've run the command Jake gave you.

mysql -uusername -p databasename < backupname.sql

[All-Madden]

lol, your cool


How from were?
mysql -uusername -p databasename < backupname.sql [/QUOTE]

[All-Madden]

Also were do i put the backup?

It on my machine now! I erased our main server nothing is left

[Steve Machol]

You need to start reading my messages closer.

Your run this from the shell command line which you access via telnet or ssh. if you don;t have this access then your best option is to ask your host to do this for you.

[Steve Machol]

Originally posted by All-Madden
It on my machine now! I erased our main server nothing is left

You need to upload the backup to your server.

[All-Madden]

I read it clearly

I asked how do i connect, and with what? I do have telnet I installed the service. but I have never done it before, i have on a linux machine, to download assignments for class but never since

[All-Madden]

Btw

Thanks for your help!