Moved to new Host Help

[Dozman]

Moved my site to the new host and I have the mysql loaded for the VB 3.8.1 L1.
I am now trying to load information_schema and I get this mysql error.

Please point me in the right direction.

Thank you.

SQL query:

--
-- Dumping data for table `KEY_COLUMN_USAGE`
--
INSERT INTO `KEY_COLUMN_USAGE`
VALUES (
NULL , 'dbxxxxxxxxx', 'PRIMARY', NULL , 'dbxxxxxxxx', 'access', 'userid', 1, NULL , NULL , NULL , NULL
)

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1 :eek:


I hope this post will help others that are moving there site.;)

[Steve Machol]

Why are you loading 'information_schema'. That is not a vB database.

[Dozman]

Thank you Steve for the quick reply.

Another had installed VB to the server about a year ago and I had to move the site after it was hacked.

I went back to old host and there are 2 database. I have the large 10 mb data loaded and online but site still comes up with Database error.

I am trying to put the 2 part called information_schema that has what look to be the memory part of VB
CHARACTER_SETS CREATE TEMPORARY TABLE CHARACTER_SETS

[Steve Machol]

That is not a vB database.

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

If you don't have telnet or SSH access, some people have reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

[Dozman]

Thank you Steve for the info. I hope to get the site back online

I did backup before the move in Admin CP

The site was sweet .;)

[Dozman]

Steve Mysql is working and I have 2 unknowns

Cpsession and Session Unknow memory.

All files size 1KB

Looks like I have to do some reading on MySql.:eek:

[Steve Machol]

Those tables should be MEMORY. Are you getting a specific error?

[Dozman]

It record and size is unknow on both

[Dozman]

Looking at structure of Cpsession and session many are unsigned.

Look like this one below.

userid int(10) UNSIGNEDNo 0

[Dozman]

Steve I have access to the old mysql and the 2 unknow are the same on that one too.

All the Mysql on the new Host is there. What I see that sticks out, on the new host is 1KB data on each

The old host mysql show tons of data on each.

[Dozman]

Steve I am going to get the Host to restore with one of the backups.sql

Thank you for you Help

I hope VB 4.0 Rocks ;)

[Dozman]

Steve

MySql 5.0.32 did not like these commands -h . -u, -p

If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the servername to the command line. The servername will be the same as in your config.php. The command line will be:

mysql -h servername -u dbusername -p databasename < backupname.sql

Or:

mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql

[Steve Machol]

You need to contact your host about this. Those are standard MySQL command line options.

[Dozman]

I have contact them and I am not getting that warm fuzzy feeling.

Thank you Steve for helping.

[express]

ON the new host just empty those tables you do not neeed any of the data in them.

Joey

Empty not delete.....

[Dozman]

They loaded the data and OMG, More work for me.:mad:

vBulletin datastore error caused by one or more of the following:

You may have uploaded vBulletin 3.6 files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.



Fatal error: vBulletin datastore cache incomplete or corrupt in [path]/includes/init.php on line 218

[Steve Machol]

vBulletin datastore error caused by one or more of the following:

You may have uploaded vBulletin 3.6 files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.

Follow those instructions.

[Dozman]

Steve woot it's back online and is back to normal.:D

Here is the issue and I hope that it helps others. ;)

From the old Host in MySQL you go to Export the database.
The Issue was, when I exported it was making the database download Latin when it needed to be utf 8 for the new host.

I told the old Host to export it for me as utf 8 and Bingo I am fixed.

Here is what you do to fix the issue. You go to your new host MySQL and if you have database in there that is messing up like mine was.

You select that database/ go to bottom and Select All and use the Drop down menu and Select DROP. Now you old Database will be removed.

Now to load the new database. You select database and click on import.
You browse for the Database and OK.

This should load with no error and if successful. Your back in Business.

Make sure to set it up to notify you when new members join and follow some of the setting posted in the forum here.

Good Luck because its the Wild west online. :D

Steve you Rock

[Steve Machol]

Glad to hear it. :)