| macman |
First Post Posted on: 05-13-12 11:16 AM |
| Sql database error |
|
| Hi\
\
I try to move my database to another server,,,I exported my database and saved it to my computer ,,then went to my other server and imported it and got\
\
SQL query: \
\
-- phpMyAdmin SQL Dump\
-- version 2.8.0.2\
-- http://www.phpmyadmin.net\
-- \
-- Host: localhost\
-- Generation Time: Aug 28, 2006 at 04:44 PM\
-- Server version: 4.1.21\
-- PHP Version: 4.4.2\
-- \
-- Database: `xxxxxxxx`\
-- \
-- --------------------------------------------------------\
-- \
-- Table structure for table `Ad_Views`\
-- \
CREATE TABLE `Ad_Views` (\
\
`ID` int( 11 ) default NULL ,\
`Count` int( 11 ) default NULL \
) 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 22 \
\
help please\
\
Thx |
|
|
|
|
|
 |
| mewsoft |
Reply #: 1 Posted on: 05-13-12 09:20 PM |
| Re: Sql database error |
|
You seems to have different mysql servers versions on both servers. To avoid this incompetibility, backup and restore using the tools in your classifidawy admin in the menu Database & SQL Manager, this does not depend on servers versions. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| macman |
Reply #: 2 Posted on: 05-13-12 11:16 PM |
| sql database |
|
| Hi\
\
if i backup using the backup and restore using the tools in your classifidawy admin in the menu Database & SQL Manager on the old server,,,,How would i put it back to the new server\
\
\
thx |
|
|
|
|
|
| mewsoft |
Reply #: 3 Posted on: 05-13-12 11:28 PM |
| Re: Sql database error |
|
You just need to transfer the directory data/database |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| macman |
Reply #: 4 Posted on: 05-14-12 01:24 AM |
| Sql database error |
|
| on my main page i cant get the catagory displayed,,,its empty\
www.hudsonvalleyclassifieds.com |
|
|
|
|
|
| mewsoft |
Reply #: 5 Posted on: 05-14-12 01:40 AM |
| Re: Sql database error |
|
| You need to use the same classifieds versions on both servers. You may be did the backup from older version and tried to restore on the latest version. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| macman |
Reply #: 6 Posted on: 05-14-12 03:19 AM |
| sql database |
|
| hi\
\
I did download the whole script from the old server and uploaded it to the new server,,,,So everything is the same except the category does not show............\
\
and also trying to get the (database) users ads to the new server\
\
thx |
|
|
|
|
|
|