Ditutup

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.

Kemahiran: PHP

Lihat lebih lanjut: 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

Tentang Majikan:
( 1 ulasan ) San Francisco, United States

ID Projek: #30958

15 pekerja bebas membida secara purata $46 untuk pekerjaan ini

DevExpert

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

$30 USD dalam sehari
(130 Ulasan)
7.4
vsworx

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

$30 USD dalam sehari
(11 Ulasan)
6.2
SachinBhatt

Can do this immediately upon receiving your approval.

$30 USD dalam 0 hari
(18 Ulasan)
5.5
eenavin

I can solve your problem in a sec

$30 USD dalam 0 hari
(2 Ulasan)
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 Lagi

$30 USD dalam 0 hari
(4 Ulasan)
4.4
LaurenceTuck

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

$30 USD dalam sehari
(1 Ulasan)
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 Lagi

$40 USD dalam 0 hari
(7 Ulasan)
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 dalam 0 hari
(2 Ulasan)
2.2
insideable

Please see PMB for bid details. Thank you.

$50 USD dalam sehari
(1 Ulasan)
1.2
bobroff

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

$30 USD dalam 0 hari
(1 Ulasan)
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 Lagi

$30 USD dalam sehari
(0 Ulasan)
1.0
lesavik

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

$30 USD dalam 0 hari
(0 Ulasan)
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 Lagi

$100 USD dalam 10 hari
(0 Ulasan)
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 Lagi

$100 USD dalam sehari
(0 Ulasan)
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 Lagi

$100 USD dalam 10 hari
(0 Ulasan)
0.0