|
Title: Migrating from one server to another Post by: imagesofvision on August 26, 2008, 07:15:16 AM I am running into a problem when trying to move my site (kite photography template) from a machine with:
phpMyAdmin 2.6.0-pl3 & MySQL 3.23.58 to a machine with: phpMyAdmin - 2.8.2.4 & MySQL - 5.0.27 I export the database from the existing machine, but when I import into the new machine i get the following error: -------------------------------------- Error SQL query: -- phpMyAdmin SQL Dump -- version 2.6.0-pl3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 25, 2008 at 06:01 PM -- Server version: 3.23.58 -- PHP Version: 4.3.10 -- -- Database: `iovjoomla` -- CREATE DATABASE `iovjoomla` ; USE iovjoomla; -- -------------------------------------------------------- -- -- Table structure for table `jos_banner` -- CREATE TABLE `jos_banner` ( `bid` int( 11 ) NOT NULL AUTO_INCREMENT , `cid` int( 11 ) NOT NULL default '0', `type` varchar( 90 ) NOT NULL default 'banner', `name` text NOT NULL , `alias` varchar( 255 ) NOT NULL default '', `imptotal` int( 11 ) NOT NULL default '0', `impmade` int( 11 ) NOT NULL default '0', `clicks` int( 11 ) NOT NULL default '0', `imageurl` varchar( 100 ) NOT NULL default '', `clickurl` varchar( 200 ) NOT NULL default '', `date` datetime default NULL , `showBanner` tinyint( 1 ) NOT NULL default '0', `checked_out` tinyint( 1 ) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar( 150 ) default NULL , `custombannercode` text, `catid` int( 10 ) unsigned NOT NULL default '0', `description` text NOT NULL , `sticky` tinyint( 1 ) unsigned NOT NULL default '0', `ordering` int( 11 ) NOT NULL default '0', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` text NOT NULL , `params` text NOT NULL , PRIMARY KEY ( `bid` ) , KEY `viewbanner` ( `showBanner` ) , KEY `idx_banner_catid` ( `catid` ) ) TYPE = MYISAM AUTO_INCREMENT =1; MySQL said: Documentation #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 'bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `t' at line 1 ----------------------------------------------- I have searched and found lots of info on this but nothing I have found works -- Any help you can provide would be much appreciated! Title: Re: Migrating from one server to another Post by: mikek on August 26, 2008, 07:48:45 AM Hi, I would contact you hosting company about this problem. The errors are showing incorrect sql syntax. All of the syntax is generate when the database is exported from your server.
Title: Re: Migrating from one server to another Post by: imagesofvision on August 26, 2008, 11:01:39 AM Problem is that I lease the two machines - the old one is a 4 year old machine with older software -
one post via google said to use compatibility mode when importing into the new db, the php admin has no such option - do you know anything about compatibility mode?? thanks for your quick response - as usual! Title: Re: Migrating from one server to another Post by: jonahh on August 26, 2008, 01:36:30 PM Try deleting the lines of SQL that the error is complaining about and then importing.
Title: Re: Migrating from one server to another Post by: imagesofvision on August 30, 2008, 12:49:02 PM problem is that the lines are the ones that create the main table in the databse...
Powered by SMF 1.1.5 |
SMF © 2006-2008, Simple Machines LLC
Joomla Bridge by JoomlaHacks.com |