Problems moving database to new server

[Dave L]

Hi,

Hope someone with some MySQL skills could help me out.

I am in the process of moving our forum (IPB 3.1.2) to a new server. I made a backup of the database and am trying to import it on the new server.

I get the following message:

Your PHP MySQL library version 5.0.77 differs from your MySQL server version 5.1.47. This may cause unpredictable behavior.

The import of course fails. I have no idea at all how to fix this. I have googled it to death but to be honest, I don't really know what I'm looking for.

I would very much appreciate any help/advice.

[Royzee]

Try doing another export of your DB using phpmyadmin check the right side for either...

SQL compatibility mode

or...

SQL export compatibility

Make sure whichever you have, that it is set to none.

[Dave L]

Try doing another export of your DB using phpmyadmin check the right side for either...

SQL compatibility mode

or...

SQL export compatibility

Make sure whichever you have, that it is set to none.

Hi Sandi,

Many thanks for your advice.

I had the Export Compatibility mode set to NONE but unfortunately still no luck.

I have also tried importing the backup file created with the IPB SQL Tools.

The database size is 49Mb.

Would there be any other options to try?

Thanks again.

[Gary.]

Have you tried doing this from the command line ? This would be the easies option to try.

[Dave L]

Have you tried doing this from the command line ? This would be the easies option to try.

Would that be using SSH?

As you can probably tell I'm not that well up to speed with that sort of thing.

I have access to SSH on the server the database is currently on but the cpanel on the new hosting doesn't have it.

Thanks.

[RogEnk]

With a 49Mb file you may find CPANEL import will timeout, as could phpMyAdmin.

Two things:

1. Export with 'Extended Inserts' option Off as this can cause similar issues to those you have - file will be bigger though!.
You can zip it, and cpanel will give you the option to unzip it once uploaded ;)

2.Get a copy of Big Dump and upload that file (single php page) after editing with your user and database details.

You now upload your export from 1. above to new server, enter url to the bigdump file from 2. above and within the page that loads point it to your exported file.

The script will then import your database for you, all being well.
It is sensitive about character sets, so a read of the FAQs etc will not go amiss.

[cargelock]

Command line (ssh) is better, on a 49mb import, it would be over in a second or two.

[Dave L]

Thanks for the replies everyone.

I tried the bigdump.php approach but it only imported 103 of the 273 tables.

I decided to try exporting the database in chunks and then import a bit at a time. This seems to have done the trick and I have all 272 tables.

However, I still have the Driver Error page and can't access the forum.

Something I have noticed looking at the new database with phpMyAdmin is the column called 'overhead' has no entries where on the old database it has some entires.

Here's the original database on the old server:



Here's the database on the new server that I'm having problems importing the old dbase to:



Appreciate any advice on how to fix.

Thanks.

[cargelock]

Overhead column is just an indicator for space in that tables that can be recovered (ie; optimised) in this instance it does not affect the running of IPB's mysql tables. Not having the overhead column filled means all your tables are at their optimum.

You need to update your version of php mysql client library. The easiest way to do that is upgrade your version of php.

[Dave L]

Overhead column is just an indicator for space in that tables that can be recovered (ie; optimised) in this instance it does not affect the running of IPB's mysql tables. Not having the overhead column filled means all your tables are at their optimum.

You need to update your version of php mysql client library. The easiest way to do that is upgrade your version of php.

Hi cargelock,

Appreciate the advice. I'll have to google it to find out how I do that.

I'll post back with an update.

Thanks again.

[Gary.]

I spotted something,

Maybe nothing but I seen your old host is using a different socket so it's been customed.

I assume you have not done any configuration, So the default address for your mysql server should be localhost.

In your conf_global php file located in the forums root try changing the host info:

your current config_global.php file will show the line:

$INFO['sql_host']			=	'localhost:3306';

Change this to:

$INFO['sql_host']			=	'cust_mysql_123_02';

If that does not work change it to:

$INFO['sql_host']			=	'cust-mysql-123-02';

The reason I said the second one is I cannot tell by the picture what symbol it is, But it's one or the other.

This should make your site load up :)

Hope I helped you out.

[Dave L]

Sorry about the late reply.

I took your suggestions on board but I was still getting nowhere.

I ended up using an older database backup and settling for having a few months posts missing.

Appreciate your advice all the same.