Just another WordPress site
To modify how many tables appear: Default value is 250, which is also the in-built default maximum value. If you type a value higher than this (which you often want to do if you have a larger database), you’ll get the following message: To increase this maximum value, you have to modify the configuration file …
Continue reading “Modify the number of tables displayed in phpMyAdmin (increase-decrease)”
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”
This command lists the tables within an sql database by decreasing size: Paste it in the “SQL” tab in phpMyAdmin. It won’t modify the database, since all it does is select entries and displays them. Source: https://chemicloud.com/kb/article/determine-size-databases-tables-phpmyadmin/