Mysql expert needed - Upload Innodb mysql database

$10-30 USD

Terminado

Publicado

hace más de 5 años

$10-30 USD

Pagado a la entrega

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 del proyecto: 17560279

Información sobre el proyecto

10 propuestas

Proyecto remoto

Activo hace 6 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 0 día

5,0

(178 comentarios)

6,3

10 freelancers están ofertando un promedio de $26 USD por este trabajo

@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 en 1 día

5,0

(34 comentarios)

4,2

@achrafchiboub

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

$25 USD en 1 día

4,7

(11 comentarios)

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 en 1 día

5,0

(9 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 1 día