sql – WordPress

update urls in database after importing to local to solve redirection issues

Am setting up a local development environment for WordPress, using VVV vagrant. I already exported the original database from production and imported it in the local placeholder website. For single-site installs, just replace the “siteurl” value in the “wp-options” from http://www.liveproductionsite.com to http://localtestsite.test For multisite-installs, there are a few more hoops to jump through. Remember: …

Continue reading “update urls in database after importing to local to solve redirection issues”

Import database with MariaDB and command line

Databases are easy to import through phpMyAdmin, but this interface has limitations. It doesn’t deal well with large files, since a timeout cancels whatever is ongoing. For larger files, it’s better to go through command line. Here are the steps to get it done:

Exporting a huge SQL database

I had to copy over a wordpress database from production to my local server. Export seemed ok, about 400+ mB but there would be errors upon importing in my local. I kept getting the ERROR 1064 (42000) at line xxx: You have an error in your SQL syntax; check the manual that corresponds to your …

Continue reading “Exporting a huge SQL database”

Show databases on vagrant server

To show which databases exist on a vagrant virtual server, do the following steps. This supposes you already have a vagrant server up and running, for example VVV. It will list all current databases, like those of wordpress installs. If you reprovision your vagrant, you should know that it will try to recreate the placeholder …

Continue reading “Show databases on vagrant server”