Urgent MYSQL issue please help.

[shanee86]

I was trying to move a client site and I am getting a error in mysql please help.

 

[Host47]

would help if you gave us the error and the process you used to backup and restore.

 

[shanee86]

I can't get it to make the error again I am trying. What we tryed first was just moving over from his old host to us using the backup in cpanel. So it worked gave no errors. But it didn't make the tables. Then we tryed in phpmyadmin using a .sql text file and got a error and I can't get the error again now it just times out on me. But I had this happen before with one of my site's and it seemed it was a php version issue and someone helped before do you know what I could do to fix it if it is a php version problem?

 

[dongan]

Not sure what might be the problem without seeing the error message.

But, it might be version conflict either MySQL or PHP.

 

[shanee86]

Yes it seems it is a version conflict I tryed to get the error again but can't. But I see his old server has Kernal: 2.6.12.3
Machine Type i686
Apache version 1.3.33 (Unix)
PERL version 5.8.7
PHP version 4.3.11 MySQL version 4.1.13-standard
There something wron with kernal

And ours:
Kernel version 2.6.9-22.EL
Machine Type i686
Apache version 1.3.34 (Unix)
PERL version 5.8.7
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
Installed Perl Modules Click to View
PHP version 4.3.11
MySQL version 4.0.25-standard

He said he thinks it is a kernel issue how can I fix that?

 

[dongan]

could u pls post the error message or error number?

 

[skrilla]

it could be somthing in ur sql file that needs changed. I have had this happen before. pm me.

 

[iNod]

When it was restored to backuped it missed something in MySql.. Just do it again until it works. Or try moving DB SQL over sepertly.

iNod.

 

[shanee86]

Finally got the error again here it is:
SQL query:

CREATE TABLE `downloads` (

`id` int( 9 ) NOT NULL AUTO_INCREMENT ,
`type` char( 255 ) NOT NULL default '',
`title` char( 255 ) NOT NULL default '',
`url` char( 255 ) NOT NULL default '',
`sname` char( 100 ) NOT NULL default '',
`surl` char( 255 ) NOT NULL default '',
`date` char( 16 ) NOT NULL default '',
`email` char( 255 ) NOT NULL default '',
`views` int( 9 ) NOT NULL default '0',
`reports` int( 9 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `id` ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 14
hope that helps thanks.

 

[dongan]

Try with this now.. It is the MySQL version conflict...

CREATE TABLE `downloads` (

`id` int( 9 ) NOT NULL AUTO_INCREMENT ,
`type` char( 255 ) NOT NULL default '',
`title` char( 255 ) NOT NULL default '',
`url` char( 255 ) NOT NULL default '',
`sname` char( 100 ) NOT NULL default '',
`surl` char( 255 ) NOT NULL default '',
`date` char( 16 ) NOT NULL default '',
`email` char( 255 ) NOT NULL default '',
`views` int( 9 ) NOT NULL default '0',
`reports` int( 9 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `id` ( `id` )
)

MySQL version 4.1.x are transaction oriented and they supports type MYISAM. The lower versions are not transaction oriented. that's the problem.

 

[RJ]

I experienced the same issue recently when moving a vBulletin site between hosts. It was an easy fix.

Like dongan is saying, you should be able to just remove the "ENGINE = MYISAM DEFAULT CHARSET = latin1" part from all off the CREATE statements in the .SQL file using a text editor.

 

[shanee86]

Thanks I will try that.

 

[skrilla]

on more thing, in your sql file you still are using the name of your old database. you must change that to the current name of of your databse. i tried uploading your sql file but it seems i dont have permission to create a new dbase. Also it almost seems as if your sql file is corrupted, but i could be wrong.

 

[shanee86]

I tried taking out the part you said still not working. It takes forever and then it does nothing when it is finally done. No error but does nothing. I am going to try changing the name of the database.

Now I just get it times out and says maximum 300 something reached it says it timed out maybe database is to big what do I do to fix that?

 

[dongan]

Now I just get it times out and says maximum 300 something reached it says it timed out maybe database is to big what do I do to fix that?

First try to import structure of the database.
Then, try to import data for each table separately.