Đã Đóng

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.

Kỹ năng: PHP

Xem thêm: 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

Về Bên Thuê:
( 1 nhận xét ) San Francisco, United States

Mã Dự Án: #30958

15 freelancer đang chào giá trung bình $46 cho công việc này

DevExpert

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

$30 USD trong 1 ngày
(130 Đánh Giá)
7.4
vsworx

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

$30 USD trong 1 ngày
(11 Đánh Giá)
6.2
SachinBhatt

Can do this immediately upon receiving your approval.

$30 USD trong 0 ngày
(18 Đánh Giá)
5.5
eenavin

I can solve your problem in a sec

$30 USD trong 0 ngày
(2 Đánh Giá)
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 Thêm

$30 USD trong 0 ngày
(4 Đánh Giá)
4.4
LaurenceTuck

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

$30 USD trong 1 ngày
(1 Đánh Giá)
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 Thêm

$40 USD trong 0 ngày
(7 Đánh Giá)
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 trong 0 ngày
(2 Đánh Giá)
2.2
insideable

Please see PMB for bid details. Thank you.

$50 USD trong 1 ngày
(1 Đánh Giá)
1.2
bobroff

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

$30 USD trong 0 ngày
(1 Đánh Giá)
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 Thêm

$30 USD trong 1 ngày
(0 Đánh Giá)
1.0
lesavik

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

$30 USD trong 0 ngày
(0 Đánh Giá)
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 Thêm

$100 USD trong 10 ngày
(0 Đánh Giá)
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 Thêm

$100 USD trong 1 ngày
(0 Đánh Giá)
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 Thêm

$100 USD trong 10 ngày
(0 Đánh Giá)
0.0