Fermé

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.

Compétences : PHP

en voir plus : 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

Concernant l'employeur :
( 1 commentaire ) San Francisco, United States

Nº du projet : #30958

15 freelance font une offre moyenne de $46 pour ce travail

DevExpert

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(130 Commentaires)
7.4
vsworx

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(11 Commentaires)
6.2
SachinBhatt

Can do this immediately upon receiving your approval.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(18 Commentaires)
5.5
eenavin

I can solve your problem in a sec

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(2 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(4 Commentaires)
4.4
LaurenceTuck

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(7 Commentaires)
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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(2 Commentaires)
2.2
insideable

Please see PMB for bid details. Thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.2
bobroff

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(1 Évaluation)
1.0
rsinfotech

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
1.0
lesavik

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0