Suljettu

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.

Taidot: PHP

Näytä lisää: find set, syntax, sql mysql, sql c, i believe, database no, 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, sql syntax, server sql, error 1064, mysql error 1064, mysql php backup, sql error 1064 mysql

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

Projektin tunnus: #30958

15 freelanceria on tarjonnut keskimäärin 46 $ tähän työhön

DevExpert

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

30 $ USD 1 päivässä
(130 arvostelua)
7.4
vsworx

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

30 $ USD 1 päivässä
(11 arvostelua)
6.2
SachinBhatt

Can do this immediately upon receiving your approval.

30 $ USD 0 päivässä
(18 arvostelua)
5.5
eenavin

I can solve your problem in a sec

30 $ USD 0 päivässä
(2 arvostelua)
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 Lisää

30 $ USD 0 päivässä
(4 arvostelua)
4.4
LaurenceTuck

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

30 $ USD 1 päivässä
(1 arvostelu)
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 Lisää

40 $ USD 0 päivässä
(7 arvostelua)
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 0 päivässä
(2 arvostelua)
2.2
insideable

Please see PMB for bid details. Thank you.

50 $ USD 1 päivässä
(1 arvostelu)
1.2
bobroff

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

30 $ USD 0 päivässä
(1 arvostelu)
1.0
rsinfotech

Dear Sir, Our team has strong experience in web site designing and development. We have biuld many websites.If you feel us relable then we can work with you. Thank You. Regards , RS Infotech Pv Lisää

30 $ USD 1 päivässä
(0 arvostelua)
1.0
lesavik

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

30 $ USD 0 päivässä
(0 arvostelua)
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 Lisää

100 $ USD 10 päivässä
(0 arvostelua)
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 Lisää

100 $ USD 1 päivässä
(0 arvostelua)
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 Lisää

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