Mysql expert needed - Upload Innodb mysql database

$10-30 USD

Teljesítve

Kiadva ekkor:

majdnem 6 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve

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

Projektazonosító: 17560279

A projektről

10 ajánlat

Távolról teljesíthető projekt

Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@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 napon belül

5,0

(178 értékelés)

6,3

10 szabadúszó adott átlagosan $26 USD összegű árajánlatot erre a munkára

@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 napon belül

5,0

(34 értékelés)

4,2

@achrafchiboub

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

$25 USD 1 napon belül

4,7

(11 értékelés)

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 napon belül

5,0

(9 értékelés)

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 napon belül

0,0

(0 értékelés)

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 napon belül

0,0

(0 értékelés)

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 napon belül