Closed

SQL Database set-up

I was wondering if you could possibly look at my sql database. I have switched to a different server that is using MySQL [url removed, login to view] and the backup uses version 4.1.13. I need someone with knowledge in MySQL because I am getting this error when trying to execute sql.

#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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14

I believe that the copy of the backup database is for version [url removed, login to view] and the current server is using 3.23.49. So we have to find the correct syntax to use for that version.

Skills: PHP

See more: find set, find in set, syntax, sql, sql mysql, sql c, i believe, database sql, database no, database c#, C# SQL, C# database, backup database, php sql syntax error, backup sql mysql, trying, 1064 php, sql different, sql backup mysql, sql syntax error, php mysql 1064, mysql copy database, mysql sql syntax, mysql database engine, execute

About the Employer:
( 1 review ) San Francisco, United States

Project ID: #30958

15 freelancers are bidding on average $46 for this job

DevExpert

I can fix the database structure to be compatible to MySQL v 3.23

$30 USD in 1 day
(130 Reviews)
7.4
vsworx

We have a team of highly qualified and creative professionals. Give us a chance to show our talent.

$30 USD in 1 day
(11 Reviews)
6.2
SachinBhatt

Can do this immediately upon receiving your approval.

$30 USD in 0 days
(18 Reviews)
5.5
eenavin

I can solve your problem in a sec

$30 USD in 0 days
(2 Reviews)
4.5
survivor

Dear Sir, Free Service Offered I have faced this manytimes on uploading form my localhost to my clients hosting Follow those steps 1- dump the DB to sql file 2- edit it 3- remove the words from "default" to the More

$30 USD in 0 days
(4 Reviews)
4.4
LaurenceTuck

Why dont you ask the server to upgrade their version of MySQL?

$30 USD in 1 day
(1 Review)
3.1
dguaraglia

Hello, Well, in fact it seems you have a problem with the table type of the database. As you are porting back to MySQL 3.X from 4.X you will get an error if trying to insert with a database type, because 3.X only kn More

$40 USD in 0 days
(7 Reviews)
3.0
Wesleyke

Hi there! I can do this for you in a short time and I can start right away. I'm very familiar with MySQL/SQL and I know what to do with this error. My price for this is only $20,00 because this is an easy job!

$30 USD in 0 days
(2 Reviews)
2.2
insideable

Please see PMB for bid details. Thank you.

$50 USD in 1 day
(1 Review)
1.2
bobroff

I know how to fix it. Will be done within an hour

$30 USD in 0 days
(1 Review)
1.0
rsinfotech

Dear Sir, Our team has strong experience in web site designing and development. We have biuld many [url removed, login to view] you feel us relable then we can work with you. Thank You. Regards , RS Infotech Pv More

$30 USD in 1 day
(0 Reviews)
1.0
lesavik

Have fixed this error many times and willing to help you!

$30 USD in 0 days
(0 Reviews)
0.0
menakamal

Hello, We are a software company backed with years of experience and the right expertise to handle all your requirements. With an in-house team of some of the best skilled hands, we assure you of quality work on tim More

$100 USD in 10 days
(0 Reviews)
0.0
pcurtis

Here's a freebie for ya ... the later version of MySQL includes a statement "TYPE=MyISAM;" in its exporting ... if you manually download the sql of the DB using PhpMyAdmin and then manually remove the line from all tab More

$100 USD in 1 day
(0 Reviews)
0.0
annierose

Hello, We are a software company backed with years of experience and the right expertise to handle all your requirements. With an in-house team of some of the best skilled hands, we assure you of quality work on tim More

$100 USD in 10 days
(0 Reviews)
0.0