I recently shifted servers and uploaded the folder accordingly.
My database file is around 70 mb so i am using Bigdump to restore it.
But when i attempt to restore, i get an error message:
Quote:
Error at the line 34: ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
Query: CREATE TABLE `photoplog_categories` (
`catid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` mediu-- Sending SELECT query...
mtext NOT NULL,
`displayorder` smallint(6) NOT NULL default '0',
`parentid` smallint(6) NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
MySQL: 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 'mediu-- Sending SELECT query... mtext NOT NULL, `displayorder` smallint(6) NOT' at line 4
|
I am really in a fix as i have no prior experience in handling this type of stuff(database)
Could anyone of you help me in rectifying my database or could provide me any alternative method of restoring the file on my new server?
I would be willing to provide you all the login details, only to a reputed member here.