Infusion Technology Solutions Blog
Technology related solutions, tips, tricks, and other interesting topics
Posts Tagged ‘mysql database’
How to Backup a MySQL Database With mysqldump
mysqldump -u userNameWithPrivileges -p databaseName > outputFileName.sql
How to Restore a mysqldump Backup
mysql -u userNameWithPrivileges -p database < outputFileName.sql
* Replace “userNameWithPrivileges” with the username of a MySQL account that can read/write to the database being backed up / restored.
- No Comments
- Tags: backup, mysql, mysql database, mysqldump, restore
Mysqldump Error 29
In: General IT Info
16 Feb 2009If you try to backup a MySQL database with a lot of tables using mysqldump, you may get an error similar to the following:
mysqldump: Got error: 29: File ‘./test/test.MYD’ not found (Errcode: 24) when using LOCK TABLES
To fix the problem you can add the –skip-lock-tables option to your mysqldump command line like so:
mysqldump –skip-lock-tables -u [...]
About this blog
This blog is about technology related topics. It will primarily contain problems and solutions to IT problems that I encounter on a day-to-day basis. In addition interesting things I come across either on or off the internet will be posted here as well. I will also include step-by-step tutorials to common tasks people may need to do with their computers.
Web Hosting Discount
-
Get the first month for only $0.01 using coupon code HGCOUPONBLOG. No contracts, cancel anytime.
Categories
- Apple (30)
- Electronics (10)
- Games (1)
- General IT Info (47)
- Information Security (12)
- Microsoft (11)
- Ramblings (3)
- The Net (5)
- Tutorials (3)
- Web Development (12)
- Don Farland: The http_proxy environment variable is case sensitive and should be all lowercase. I dropped it in [...]
- brad: I can confirm that this works for the newest 3.0+ software. works like a charm thanks to the creator [...]
- Jim Tidmore: Hello, I believe I followed everything but doesn't connect, don't get me wrong I am not complaining [...]
- Tom: Thanks for the clear and concise information. Tom [...]
- JAUHDIMATA: good solved.. thx [...]
- How to Reset the Password for an OS X Open Directory Mobile Account
- Terminal Command for Xserve Intel Hardware RAID Card
- How to Fix a Corrupted OS X Open Directory Account Password
- How to Configure Splunk to use a Web Proxy Server
- How to Get Trixbox Working Behind a NAT Firewall
- How to Backup and Restore a MySQL Database Using mysqldump
- How to Reset the Admin Password in ColdFusion MX 6
- How to Enable ReadyBoost for an ExpressCard SSD in Vista
- Sendmail Hangs When Starting Up or When Using It with PHP
- Mysqldump Error 29
Revolutionary One Time Password Device
