Most voted "mysqldump" questions
14 questions
Sort by count of
-
7
votes1
answer2867
viewsBackup all tables except one
In Mysql we can perform backups via terminal as follows: Database mysqldump nomeBaseDados > meuFicheiroBackup.sql Table mysqldump nomeBaseDados nomeTabela > meuFicheiroBackupDaTabelaX.sql How…
-
3
votes1
answer2019
viewsAutomatic backup with Mysql
Is it possible to perform automatic backup in mysql? Example: I direct a folder that Mysql will generate every day at 18:00 the backup of the database.
-
3
votes1
answer280
viewsDump from all banks to a specific user
I have user plant652 who has 54 databases and need to back up all of them. How to do them all at once in Centos 6 with cPanel?
-
2
votes1
answer189
viewsBackup by mysqldump line by line
I am using mysqldump to export only my database data, but when exporting, it shows only one line with all the Inserts. Is it possible to make a registration insert per line? Ex: INSERT INTO TABELA()…
-
1
votes0
answers55
viewsDUMP Mysql based mto large (Blobs)
I need to make a DUMP of a giant base, it has more than 500.000 Pdfs files uploaded into it in a field BLOB. It is possible to make a DUMP from such a base and restores it smoothly? If yes, how to…
-
1
votes0
answers48
viewsLow memory after mysqldump
I’ve been observing that always after running mysqldump, the server’s free memory gets very low and is not released right away. The command I’m using is mysqldump --default-character-set=latin1…
-
1
votes1
answer1434
viewsHow to execute a command in CMD or Powershell, passing the commands via C#?
I need to execute a command on CMD that I pass the parameters via C# for example: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\mysqldump.exe" --column-statistics=0 -uroot -p1234 -hservidor -P3306…
-
0
votes1
answer314
viewsAvoiding dump for Mysql users
For a specific Mysql user, there is a way to block it from doing the Data Export (DUMP) of a specific table, or of the entire database? I couldn’t find a solution... How you handle it? Thank you!…
-
0
votes1
answer588
viewsbackup of specific mysql content data via java
Hello, I have the following method that backs up my database: public static void makeBackup() throws IOException{ String caminho = "C:\\Program Files\\MySQL\\MySQL Workbench 6.3 CE\\mysqldump.exe";…
-
0
votes1
answer99
viewshow to restore Mysql Database
I tried to do the following to restore the database: root@m9r9w9gae3 [/bkp/var/lib/mysql]# mysqldump -u root -p nomedobd > /home/nmedobd.sql or: root@m9r9w9gae3 [/bkp/var/lib/mysql/nomedobd]#…
mysqldumpasked 7 years, 11 months ago Murilo Ferro 107 -
0
votes0
answers194
viewsAccent problem when doing mysql Dump in C# (latin1 and utf8)
I made a program in c# that dump in mysql, it is very cool, it selects the bank and does the dump alone,making a sql file on my computer, and I just need to climb the bank later to where I wish.…
-
0
votes1
answer265
viewsProblem with punctuation and space when running CMD via C#
I have a program in C# that uses a button to execute a command on the CMD. This command is used to take a database on a server and put it on the machine in a path you choose(Mysqldump). private void…
-
0
votes1
answer103
viewsmysqldump generating the same file with different size
Good morning, you guys. I’m having a bizarre problem using the mysqldump, I’ll try to explain as best I can. I have 4 Databases, and daily a dump is made from each base, generating different files,…
-
0
votes0
answers9
viewsError when exporting a database using mysql Workbench 8.0
This is my first time using Mysql WORKBENCH, I’m having problems when exporting a database. In the image below are the parameters that I configured in the Data Export tab before starting the…