Moving my vB

[flup]

I'm gonna move my vB to a paid server, but i extually don't know howto.

I think like this:
> Backup files from server I'm now having
> Backup database
> Store files on new server
> Store backup on new server

But, don't I need to remake those tables & stuff?
And isn't it destroying my hacks so I have to re-do them?

[Steve Machol]

<a href="http://www.vbulletin.com/manual/movingservers.html" target="_blank">http://www.vbulletin.com/manual/movingservers.html</a>

[flup]

Ty lad

[flup]

Ok tried it. didn't work.
I want to make a "backup" in text file format.
So i can make tables and content in phpmyadmin

But how do i make such a text file

[flup]

^BUMP^

Need this before 1feb

[Steve Machol]

What exactly did toy try that 'didn't work'? All backups are in text format.

[flup]

Well, i couldn't make a Dbase backup.
So i did it in the admin CP (SQL file)

next step i tried to extract it:
mysql -uUSERNAAM -p dbasenaam < /www/forums/vbulletin.sql

But it says: /www/forums/vbulletin.sql doesn't excists.
But, im not a n00b, I know where i stored it, and it really excists when i look with SSH in the folder.

Next step is i tried to add is via a SQLmanager, but instead of the Dbase name wich is stored in the SQL file, it creates a dbase: vbulletinsql

Next i tried is to change dbase name to vbulletinsql on localhost.
But also that won't work.

After trying that, I wanted to try it via SqlMyAdmin so i saw the Dbase, selected the SQL file on my harddisk and tried to import that one in the excisting EMPTY database. But i got a Import error after 15min of waiting.

I really dunnow what to do now :(

[Steve Machol]

Try:

mysql -uUSERNAAM -p dbasenaam < www/forums/vbulletin.sql

Or just cd to the directory containing the file and use:

mysql -uUSERNAAM -p dbasenaam < vbulletin.sql

[flup]

Ok will try

[flup]

Would it be good by trying to download the db file again?


ERROR 1064 at line 9854: You have an error in your SQL syntax near ''????\0JFIF\0\0,,\0\0??\0C\0(#(#!#-+(0<dA<77<{X]Id_???_??_???' at line 1



what could this be?

[filburt1]

FTP it in binary mode.

[Steve Machol]

The backyup file is ASCII unless you've compressed it.