Mysql expert needed - Upload Innodb mysql database

$10-30 USD

Завершено

Опублікований

over 5 years ago

$10-30 USD

Оплачується при отриманні

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

ID проекту: 17560279

Про проект

10 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@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 за 0 день

5,0

(178 відгуки(-ів))

6,3

10 фрілансерів(-и) готові виконати цю роботу у середньому за $26 USD

@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 за 1 день

5,0

(34 відгуки(-ів))

4,2

@achrafchiboub

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

$25 USD за 1 день

4,7

(11 відгуки(-ів))

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 за 1 день

5,0

(9 відгуки(-ів))

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 за 1 день

0,0

(0 відгуки(-ів))

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 за 1 день

0,0

(0 відгуки(-ів))

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 за 1 день