To run mysqldump, you’ll need a few things handy: Here’s the setup screen for that in Coda: Some software can help you connect to your server through SSH. To run mysqldump, you’ll need to access the command line for your server. sql file generated by mysqldump, you’d end up with an exact copy of your WordPress database – which is what we’re trying to get! If you were to run each of the SQL commands in the. sql file, which is just a list of SQL commands – CREATE TABLEs, INSERTs, etc. With default settings, mysqldump will generate a. Mysqldump is an appropriately-named program for dumping a MySQL database. Recommended for: Development & non-critical sites.If you aren’t comfortable with it, skip to the next section on using phpMyAdmin for backups. But even if you’re afraid of the shell, backing up using mysqldump isn’t too awful hard. Using the command line for backups is a manual process, and can be a bit daunting if you’re not comfortable on the command line. Let’s walk through some of the ways you can back up your WordPress database. How (and how often) you take backups will vary depending on the importance of the site you’re working on. WordPress database backups can be taken numerous ways, ranging from “highly-technical” to “supremely easy”. At the very least, you don’t rely on a single copy of your code – that’d be risky! So let’s take that same care with the much more important database. If you’re a WordPress designer or developer, think about how much care you take to save the PHP, HTML, or CSS code you write. Holy cow – you can’t lose that stuff! It doesn’t matter if your site is big, small, live or in development – backing up is for every WordPress site. Layouts & templates (if you use a fancy drag-and-drop theme).You probably know your actual content is in the database: blog posts, pages, custom post types, comments, etc.īut the database stores more than content. WordPress stores a ton of important stuff in the database.
0 Comments
Leave a Reply. |