Move OsCommerce DB to New Server

Move OsCommerce DB to New Server is project number 120608 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider Dek7
Budget:	$30-100
Created:	01/22/2007 at 20:40 EST
Bidding Ends:	01/27/2007 at 20:40 EST
Project Creator:	unl0ad   Buyer Rating: (11 reviews)
Description:	I am attempting to move an oscommerce shop from one server to another. I have tried to use the backup feature in the oscommerce admin panel but receive the following errors; --------------------------------------------- 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 '; -- -- Dumping data for table `address_book` --' at line 35 -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 17, 2007 at 02:30 PM -- Server version: 4.1.22 -- PHP Version: 4.4.2 -- -- Database: `kkqeadtl_osc4` -- -- -------------------------------------------------------- -- -- Table structure for table `address_book` -- CREATE TABLE `address_book` ( `address_book_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `entry_gender` char(1) NOT NULL default '', `entry_company` varchar(32) default NULL, `entry_firstname` varchar(32) NOT NULL default '', `entry_lastname` varchar(32) NOT NULL default '', `entry_street_address` varchar(64) NOT NULL default '', `entry_suburb` varchar(32) default NULL, `entry_postcode` varchar(10) NOT NULL default '', `entry_city` varchar(32) NOT NULL default '', `entry_state` varchar(32) default NULL, `entry_country_id` int(11) NOT NULL default '0', `entry_zone_id` int(11) NOT NULL default '0', PRIMARY KEY (`address_book_id`), KEY `idx_address_book_customers_id` (`customers_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=215 ; -- -- Dumping data for table `address_book` -- [TEP STOP] 1146 - Table 'unl0ad_osc1.sessions' doesn't exist select count(*) as total from sessions where sesskey = '1fcd307107ef0ca7d5803d90cececb59' [TEP STOP] --------------------------------------------- **** MAX PAYMENT FOR THIS IS $10 PAID VIA PAYPAL AFTER COMPLETION **** MAX PAYMENT FOR THIS IS $10 PAID VIA PAYPAL AFTER COMPLETION
Job Type:	PHP Script Installation
Database:	MySQL
Operating system:	Linux
Bid count:	12
Average bid:	$ 36