Mysql expert needed - Upload Innodb mysql database

$10-30 USD

Completed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

I need help in uploading a 2.5gb my sql database on cpanel. Im trying to upload it, gives the following error... ---Error----- Error at the line 276: ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; Query: CREATE TABLE `am_scheckout_config` ( `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `store_id` smallint(5) unsigned DEFAULT NULL, `variable` varchar(255) DEFAULT NULL, `value` varchar(255) DEFAULT NULL, PRIMARY KEY (`config_id`), UNIQUE KEY `store_id_variable` (`store_id`,`variable`), KEY `IDX_AM_SCHECKOUT_CONFIG_STORE_ID` (`store_id`), CONSTRAINT `FK_AM_SCHECKOUT_CONFIG_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 MySQL: Cannot add foreign key constraint

Database Administration

Project ID: 17560279

About the project

10 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@glennwilkins

sir pm me i will help you ... sir pm me i will help you ... sir pm me i will help you ... sir pm me i will help you ...

$20 USD in 0 day

5.0

(178 reviews)

6.3

10 freelancers are bidding on average $26 USD for this job

@Walrusyn

Hi, I'm a Linux sysadmin with 17 years of experience and would love to help you with this task. I have experience with MySQL as you can see on my reviews and would love to help. Looking forward to hearing from you. Best regards, Marco Ramos

$25 USD in 1 day

5.0

(34 reviews)

4.2

@achrafchiboub

Hi, I can do this work . Ping me for more details...

$25 USD in 1 day

4.7

(11 reviews)

3.8

@chotuactive

Dear Client, I can solve your foreign key constrain issue. To solve this issue, I need your database overview. I have good knowledge on MySQL and Cpanel management so I think that I am the best person who can solve your issue. Do you have shared hosting / VPS? If you have VPS then do you have admin access of server . Please feel free to contact with me. Regards Heena Agrawal

$35 USD in 1 day

5.0

(9 reviews)

2.9

@Creotix

Hi, You seem to be having an issue with foreign key reference while importing a database via cPanel. You need someone who has enough experience with MySQL to troubleshoot it. How about you let me fix it for you? I have a question as well. Do you still have access to the source database? It'll help in troubleshooting the issue faster. PS: I'm new to freelancer that's why I don't have any work history. Once you contact me I'll be able to share proof of my work. Thanks.

$15 USD in 1 day

0.0

(0 reviews)

0.0

@kgfrnd82

I think I can understand your problem ... I can help you to solve the error... i have already faced this kind of error in different platform ... hope that you will have solution depending upon my previous experience..

$30 USD in 1 day

0.0

(0 reviews)

0.0

@ficriver

Hi there, As i see in your project description error raise at the CREATE TABLE query (DDL Operation), exactly when create table 'am_scheckout_config' which references to table 'core_store'. The error may be occurs because table 'core_store' not created yet or have different column 'store_id' definition. I need to see query for CREATE TABLE 'core_store', and what number line is the query? Don't send me 2.5GB file,

$25 USD in 1 day