Käynnissä

Move OsCommerce DB to New Server

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 -- [url removed, login to view] -- -- Host: localhost -- Generation Time: Jan 17, 2007 at 02:30 PM -- Server version: [url removed, login to view] -- 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 '[url removed, login to view]' 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

Taidot: PHP, Komentosarjan asennus

Näytä lisää: move oscommerce server, select count total sessions sesskey, moving oscommerce server, php script null, php new version, new line in php, new data structure, key data structure, int i, oscommerce default charsetlatin1 auto_increment1, oscommerce tables structure, oscommerce move shop different server, error oscommerce backup dont exist, oscommerce backup sql 1064, select count total sessions sesskey 1146, move oscommerce localhost host, moving oscommerce server backup database, `address_book_id` int11 line, address_book doesnt exist oscommerce, move oscommerce shops, table doesnt exist select value sessions sesskey osc, move oscommerce shop server, oscommerce moving server, address_book doesnt exist, moving oscommerce site server

Tietoa työnantajasta:
( 42 arvostelua ) Austin, United States

Projektin tunnus: #120608

Myönnetty käyttäjälle:

Dek7

It can be done easily and perfectly :) Price: 10$

$30 USD 0 päivässä
(21 Arvostelua)
4.5

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

hasnut

Not a problem at all

$30 USD 0 päivässä
(140 arvostelua)
6.3
pgcoding

will charge $10 per hr. This may involve some serious trouble shooting and [url removed, login to view] pmb for portpolio.

$30 USD 1 päivässä
(26 arvostelua)
6.2
phpsmith

I can do this today

$30 USD 0 päivässä
(23 arvostelua)
4.7
pvarsha

Hello , I am interested to do this job for you. Presently i am working on oscommerce and creloaded based projects. For more details plz see my reviews and profile. Assure you to give best service and maintainance Lisää

$30 USD 1 päivässä
(10 arvostelua)
4.1
SOMNIVM

I'll do it for $10 :)

$30 USD 1 päivässä
(9 arvostelua)
3.9
spkar

Check PM for more details

$30 USD 1 päivässä
(1 arvostelu)
3.2
innox

10$ that's perfect for me. I can do this right now.

$30 USD 1 päivässä
(1 arvostelu)
1.6
Syndel

If it is solely to copy the database from the original place it is at and put in the new one, I would go for the 10 dollars. Now if it is to check installation and functionality of the shop, it is too few.

$30 USD 1 päivässä
(0 arvostelua)
0.0
otherjoe

Please see my PM

$100 USD 2 päivässä
(0 arvostelua)
0.0
Adham

Dear Project Creator We are team of professianal Web designers and programmers. Please check PM. thanks

$30 USD 0 päivässä
(0 arvostelua)
0.0
mastercode

Hello sir! please check PMB for more details. Thanks...

$30 USD 0 päivässä
(0 arvostelua)
0.0