Questions tagged [mysqldump]
mysqldump : MySQL's Client Backup Utility
53
questions
2
votes
1
answer
3k
views
mysqldump on windows with mysql 8 community
I have MySQL 8.0.26 installed but when I type mysqldump in PowerShell I get a The term 'mysqldump' is not recognized error.
When I open up the installer everything is installed.
Back in the day ...
- 7,232
0
votes
1
answer
2k
views
Mysqldump Errcode: 24 - Too many open files
When I attempt to back up one of my database I am getting the following error.
mysqldump: Got error: 23: Out of resources when opening file './mysql_db/table_name.MYD' (Errcode: 24 - Too many open ...
- 101
0
votes
1
answer
911
views
XAMPP Mysql shutdown unexpevtedly
Please, my MySQL is damaged after my PC suddenly shutdown.
18:05:24 [mysql] Error: MySQL shutdown unexpectedly.
18:05:24 [mysql] This may be due to a blocked port, missing dependencies,
18:05:24 [...
0
votes
1
answer
46
views
Mysqldump works but not mysql client
How is that possible that on the same system I can use mysqldump but not mysql?
While mysqldump works fine, the mysqlclient says, root user access is denied. Explicit parameter to connect to the ...
- 471
1
vote
1
answer
1k
views
My mysqldump script keeps failing, says there's no preceding group in my.cnf
So mysqldump throws the following error:
mysqldump: [ERROR] Found option without preceding group in config file /etc/mysql/my.cnf at line 22!
mysqldump: [ERROR] Fatal error in defaults handling. ...
- 27
0
votes
1
answer
119
views
Why mysql 5.6 is not installing
I have tried installing mysql server several times but am frustrated because none of the versions has worked. Am getting an error message that "there is an error in XML document (0,0). This installer ...
- 11
1
vote
1
answer
98
views
Restore SQL Database from full system backup
long story short I am restoring a failed server. I have a backup of most of the file system. I need to restore the SQL databases but I don't have a copy of the mysqldump. so I've restored the files to ...
- 11
2
votes
1
answer
2k
views
Best method to transfer/clone large MySQL databases to another server
I am running a web application within a shared hosting environment which uses a MYSQL database which is about 3GB large.
For testing purposes I have setup a XAMPP environment on my local macOS ...
- 163
2
votes
1
answer
608
views
mysqldump from a local machine, no ssh access to remote
I can ssh to a a server (on a private network, via VPN connection), that has Apache installed on. Internal ip for this server is 192.168.10.98.
Web framework on this server can connect to MySQL server ...
- 123
1
vote
2
answers
2k
views
Extract portion of text file from first occurrence of one string to first occurrence of another
How can I extract a portion of a large text file, starting at the first occurrence of FOO and ending at the first occurrence of BAR?
In my case, I'm trying to extract a portion of a sql file created ...
- 177
1
vote
1
answer
1k
views
How to disable mysqldump command
I want to disable mysqldump command for all user's including root. As I am taking DB snapshot.
After removing mysqldump binary file from /usr/bin/ location. But is it safe to do so?
- 13
1
vote
1
answer
1k
views
mysqldump: specify per-user db name in ~/.my.cnf
I'm running a shared server with multiple users. Each user has their own database in MySQL and associated credentials. I've created a template systemd timer & service (ie. [email protected] & ...
user826076
0
votes
2
answers
80
views
MySQL backup using cmd
When I try to backup my DB using command prompt command
mysqldump -u root -p db_name > path to store
It prompts
Enter password:
And within seconds before I enter my password, it redirects back ...
- 1
-1
votes
1
answer
379
views
Ubuntu 14.04 unable to install/find mysqldump
I have a VPS with a working CMS (Ubuntu 14.04 LAMP).
CMS is perfectly working, but I'm not able to automate back-up (rsnapshot witch scripts calling mysqldump) cause I can't find mysqldump in the ...
- 1
0
votes
0
answers
214
views
Attempt to import dump-file into remote MySql server generates error -"1449"
Attempt to import .sql file generated by mysqldump.exe into another MySQL Server generates Error - "1449: The user specified as a definer(jboss@localhost) does not exist".
So far I have attempted to -...
- 51