Backup recipebooks aplication with phpmyadmin

[kaneco]

Hello

I recently changed my server from the old on to the new one
I have done the backup to the databases like the recipebooks
But when I try to upload the file I have I receive a message:

No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

How can i solve this problem in oder to put all data inside to the database again
Because the file i have backup is 2.958kb in zip format
and the maximum allowed is 2,048 KB in phpmyadmin

please help me to solve this issue

best regards

[bigfoot65]

Can you unzip the file? Then you can open the file, copy the text and paste into phpMyAdmin SQL window. Run it and the database should be populated.

Keep in mind you might need to empty the current database first.

[kaneco]

hello bigfoot,

I have Google a little and I found a way to increase the import limit in the phpmyadmin is edit the file etc/php.ini and change this parameters:

post_max_size = 50M
upload_max_filesize = 50M

after this i don't have the error with the limit but i have a new one:
Erro

Comando SQL:

--
-- Extraindo dados da tabela `recipe_bases`
--
INSERT INTO `recipe_bases` ( `base_id` , `base_desc` )
VALUES ( 1, 'Carne Vaca' ) , ( 2, 'Carne Porco' ) , ( 3, 'Carne Aves' ) , ( 4, 'Marisco' ) , ( 5, 'Peixe' ) , ( 6, 'Ovos' ) , ( 7, 'Pão' ) , ( 8, 'Vegetais' ) , ( 9, 'Frutas' ) , ( 10, 'Bebidas Alcolicas' ) , ( 11, 'Bebidas não Alcolicas' ) , ( 12, 'Pasta' ) , ( 13, 'Massas' ) , ( 14, 'Bolos' ) , ( 15, 'Tartes' ) , ( 16, 'Doces' ) , ( 17, 'Semi-frio' ) , ( 18, 'Gelados' ) , ( 19, 'Saladas' ) , ( 20, 'Puré' ) , ( 21, 'Carnes mistas' ) ;

Mensagens do MySQL : Documentação
#1062 - Duplicate entry '1' for key 'PRIMARY'

can you please help me with this

Best regards

[bigfoot65]

Did you empty the database first before trying to load your backup? If not, you will have issues.

[kaneco]

Hello

Empty the database? do you mean click over all check box inside the recipedb databased and select delete (upper left corner) or do you mean select the clear in front of all items in the database??

Best regards

[bigfoot65]

Best if you read the documentation for phpMyAdmin on how to delete records in tables. I do not use it much, do mine from the command line.

[kaneco]

Hello Bigfoot,

Thank you for your help, I perform the clean to the database and now is working fine. I have put all data again in database, whithout no probems.

Best regards

And thank you again for your help

[bigfoot65]

Awesome. Glad it worked out.