Mysql expert needed - Upload Innodb mysql database

$10-30 USD

Dokončeno

Zveřejněno

před více než 5 roky

$10-30 USD

Zaplaceno při doručení

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

IČ projektu: 17560279

O projektu

10 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 0 dni

5,0

(178 recenze)

6,3

10 freelanceři nabízejí v průměru $26 USD za tuto práci

@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 v 1 dni

5,0

(34 recenze)

4,2

@achrafchiboub

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

$25 USD v 1 dni

4,7

(11 recenze)

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 v 1 dni

5,0

(9 recenze)

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 v 1 dni

0,0

(0 recenze)

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 v 1 dni

0,0

(0 recenze)

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 v 1 dni