MySQL Forums
Forum List  »  French

cmd mysqldump avec -w
Posted by: alex jour
Date: June 16, 2015 02:28AM

Bonjour,

Voila mon probléme, je veux faire un dump de ma base mais seulement avant une date.

"C:\...\MySQL\bin\mysqldump.exe" -u root --skip-add-drop-table -r createTable --port=3306 maBase mod_bi_time mod_bi_metricdailyvalue -w "mod_bi_time.id < 10"

j'ai essayer mais sans succés, dans la table mod_bi_metricdailyvalue, la clé étrangére de la table mod_bi_time se nomme time_id.
Deplus pour l'instant je le fais que sur deux tables pour tester mais plus tard je vais avoir plusieurs table de cette base a dumper, dont la plupart ne sont pas lier directement a mod_bi_time.

Quelqu'un aurait une solution s'il vous plait ?

Cordialement.

Options: ReplyQuote


Subject
Views
Written By
Posted
cmd mysqldump avec -w
2940
June 16, 2015 02:28AM
1533
June 16, 2015 02:48AM
1774
June 16, 2015 03:25AM
1920
June 16, 2015 03:34AM
1654
June 16, 2015 03:44AM
1681
June 16, 2015 03:49AM
1823
June 16, 2015 06:00AM
1721
June 16, 2015 06:15AM
1481
June 16, 2015 06:38AM
1841
June 16, 2015 06:41AM
1778
June 16, 2015 06:47AM
1486
June 16, 2015 06:57AM
1498
June 16, 2015 07:08AM
1540
June 16, 2015 07:21AM
1512
June 16, 2015 07:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.