Now that we have covered how to make a backup of your MySQL database, we can go over how to import the backup. To do this, you can use the cat command: This command uses cat to write your database to stdout and then pipes it into mysql. You’ll need to have your database created first, but you […]
Category Archives: mysql
How to Back Up a MySQL database
One of the worst mistakes you can make is not having a backup of your database. When something goes wrong, you will be sorry. And the thing about backing up a database is that not everyone knows how to do it. There’s no simple drag and drop a copy and you’re done. Since there is […]
MySQL fails to start
I recently ran into an issue where the MySQL database service would not start on my server. After searching around a bit (and being led astray a few times), I found the culprit: not enough RAM. It turns out that my set up (Ubuntu 12.04 with 256 MB RAM) did not have a enough memory […]