Welcome Visitor, Please Login or Register Now Monday, February 10, 2025 01:33 PM 
Forums Index > Mewsoft Products > Classifiedawy > Sql database error
New Topic   New Reply
Search for:
Author Message
macman macman's personal page
Registered Member
Posts: 95 Display member's posts
Joined: 09-20-05 01:02 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Sql database error Edit Delete Reply with quote Quote
First Post Posted on: 05-13-12 11:16 AM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 02-10-25 01:33 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Sql database error Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 05-13-12 09:20 PM next post previous post

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 macman's personal page
Registered Member
Posts: 95 Display member's posts
Joined: 09-20-05 01:02 PM
Member Offline
View Member's Profile Send private message
 
Back to top
sql database Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 05-13-12 11:16 PM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 02-10-25 01:33 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Sql database error Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 05-13-12 11:28 PM next post previous post

You just need to transfer the directory data/database


Mewsoft Support
www.mewsoft.com
macman macman's personal page
Registered Member
Posts: 95 Display member's posts
Joined: 09-20-05 01:02 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Sql database error Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 05-14-12 01:24 AM next post previous post
on my main page i cant get the catagory displayed,,,its empty\ www.hudsonvalleyclassifieds.com
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 02-10-25 01:33 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Sql database error Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 05-14-12 01:40 AM next post previous post
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 macman's personal page
Registered Member
Posts: 95 Display member's posts
Joined: 09-20-05 01:02 PM
Member Offline
View Member's Profile Send private message
 
Back to top
sql database Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 05-14-12 03:19 AM last post previous post
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
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print  

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.3355 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation