Transfer

[oninuva]

Is this how I transfer?

Upload /root files

Then Import database?

[rogersnm]

it would be a good start ;)

or import the database and then upload all the files, or do them both at the same time....

[oninuva]

I did that and it dosnt work. :(

[Smiry Kin's]

I did that and it dosnt work. :(
dont see why not make sure your doing it right. e.g trying to connect to the right database... if you need any more help pm .e

[Kirk Y]

Could you be a little more descriptive and tell us what exactly isn't working?

[oninuva]

Well this is what I did.

I made a home backup from the old host.

I made a database backup from the old host.

I go onto the new host and upload the home backup. Takes like 2 hours.

I go onto the new host and upload the database backup.

I give the permissions to the new database.

Go onto the site. Error.

Does not send me a error message :(

[Kirk Y]

Click View -> Source Code/Page Source and you'll see the vB mySQL Error commented out: <!-- Error Stuff -->.

Have you changed your includes/config.php settings to reflect the Username/PW of your new mySQL DB?

[oninuva]

Yeah its the same. Or should be.... hmm

ok here is the error:



Invalid SQL:

SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron','userstats','birthdaycache','maxlo ggedin','iconcache','eventcache','mailqueue');

MySQL Error : Table 'gamerzf_forum2.datastore' doesn't exist
Error Number : 1146
Date : Thursday, July 27th 2006 @ 06:57:41 PM
Script : http://www.gamerz-forum.com/forum/
Referrer :
Username :
Classname : vb_database

[Kirk Y]

Do you have phpMyAdmin on your new server? Go take a look at your database with it -- from what I can ascertain from this error message, you're missing tables, meaning that your SQL was only partially restored or wasn't at all.

[oninuva]

Why would only half be restored? Should i try uploading it agian?

[Kirk Y]

If your tables are missing -- and they obviously are, I'd recommend it.

How big is your SQL backup?

[oninuva]

Ok my DB is about 6.8 mb When i restore through cpanel if it says
Restoring Database

Does that mean its done?

[Kirk Y]

-ing means ongoing or in the process of. -ed means finished or no longer processing. ;)

6.8 MB might be too big to restore through cPanel or phpMyAdmin. You might have to split it up into smaller chunks or restore via Shell/SSH.

[oninuva]

how do i split it up? into chunks

[Mastar]

The old DB might be corrupt

[oninuva]

No. Its brand new.

[Guest210212002]

You might need to edit config.php. You should just import via SSH.

And once again, please make more appropriate thread titles.

[Kirk Y]

To split it up, just open the .SQL file in a text editor like Notepad/Wordpad and cut and paste chunks of the code into seperate files, just be sure that wherever you cut out ends in a semicolon (;).

You could also use a staggered importer like BigDump (http://www.ozerov.de/bigdump.php).

Or as Chris said, if you've got Shell/SSH it'd be easier to import it using that. It's probably not enabled by default, so you'll have to ask your Webhost to enable it for you.

[rogersnm]

I set it up for him through big dump :)

Link is here: http://www.gamerz-forum.com/forum/

[oninuva]

To split it up, just open the .SQL file in a text editor like Notepad/Wordpad and cut and paste chunks of the code into seperate files, just be sure that wherever you cut out ends in a semicolon (;).

You could also use a staggered importer like BigDump (http://www.ozerov.de/bigdump.php).

Or as Chris said, if you've got Shell/SSH it'd be easier to import it using that. It's probably not enabled by default, so you'll have to ask your Webhost to enable it for you.

So when i copy and paste the chunks out do I name the file the same as the DB?

[Kirk Y]

No you can name it whatever. Say you start from the top of the SQL file, cut out 1/3 of the file and then save it in a new file called SQL1, then do the remainder of the and save each file as SQL2, SQL3, and so on and so forth. Then in phpMyAdmin, use the import feature and import each SQL file consecutively.

But I think rogersnm set you up -- or something, if I'm understanding him correctly.

[rogersnm]

Yes, i have set him up. He didn't think i did. But now he has realised :)

[oninuva]

No I dont. How do you have my Cpanel and Stuff?

[rogersnm]

you told me it the other day when you were trying to import the databse the first time but cpanel wa buggered.