Moving probs

[pie]

Hey guys,

I have downloaded files off one server and reuploaded on another. (as its hack files and database need up)

i have here 2 versions of my database. Complete Inserts/Extended Inserts etc. and one without. All Save as File and all selected structure and data.

Where am i going wrong?

Only other thing i can suggest myself is Exporting as coding and importing as code. But i'll have to do this on a faster connection which is when my mates online (As he'll follow my instructions).

:bunny: TIA

[filburt1]

You need to make the backup as per http://www.vbulletin.com/manual/movingservers.html :)

[pie]

cheers Filburt but as i regged the domain before my server i got some supportless webspace. so no SSH on one pc, kinda defeats the object of that tutorial.

[pie]

/bump..... i need to do this very soon as i dont have long till my hosting goes buh-bye

[filburt1]

Sorry but short of asking your host to make the dump for you there's nothing you can do to make a reliable dump.

[N9ne]

Yep, SSH/telnet is the only current reliable way of making a dump of a database...:(

whatever you do, don't use phpMyAdmin...

[pie]

heh, thats the only thing i got access too on that server. My forum has been blanked 4 times now. :| I can NOTTTTTTTTTTTTTT loose the database :(.

Is there not a way i can access the database via my server and backup like that?

[filburt1]

No. The ways we've reviewed are the only reliable ways. Any decent host should offer SSH or at a bare minimum make a dump for you.

[Tigga]

I've had a problem before where I didn't have SSH access on a server and had to use this little cgi script to execute the commands. It worked just fine for me to restore a 300+ mb database, so hopefully it will help you out. Just upload the attached file to your cgi-bin and go to the URL in your browser. You can change the password in the file itself, or just leave it as "password". Then you would want to use this command with your database password already in it...

mysql -uUSERNAME -pDBPASSWORD newdbname < /path/to/dump.sql

Hope that helps. :)

Ok, and I just realized that you can't attach a .pl file here, so you'll have to rename the file from telnet.php to telnet.pl

[pie]

cheers bud

[filburt1]

You'll need Perl for that, though, so make sure you have it.

[pie]

i have no cgi bin :rolleyes: *crys.

Could i use it on a plan that on my server where i do have CGI and remote location it *blushes. lol

[Tigga]

Have you tried creating a new folder called cgi-bin and setting permissions to 755? If you don't even have a cgi-bin you seriously need to find a new server.

[colicab-d]

Is there any way you could take the database peice by peice off. I mean in little bits.

I wouldnt mind if it took me an hour or 2. i CANNOT let the db go down.