Increase the Upload Size for MySQL Database in cPanel with phpMyAdmin
cPanel/WHM Server imposes a limit on the size of importing a WordPress MySQL database that can be imported into phpMyAdmin. The default size is 50MB which is set in the cPanel/WHM settings. You can change the settings either in cPanel or separately in WHM depending on what you have available. Failing that there are other ways…
Read MoreRemove MySQL database server from macOS or OSX via the command line
To remove an instance of MySQL Database Server from your macOS or OSX installation you need to delete a number of files via the command line, but first ensure that you have database dumps of your databases and that then the database server is not running. Back Up any needed MySQL databases Launch the command…
Read MoreInstall Apache, MySQL, PHP on macOS 11 Big Sur and earlier macOS
Get your Local Web Development Environment Up & Running on macOS Big Sur 11 and Catalina 10.15 With Apples’ new macOS Big Sur 11 available for download, here is how to get the AMP stack up and running on the new macOS. This tutorial will go through the process of getting Apache, MySQL, PHP (or…
Read MoreHow to connect to a MySQL or mariadb database with PHP
This tutorial will require a mysql database set up with a database user and password and a web development environment using mysql or mariadb, apache and php and a simple text editor. The tutorial takes you through establishing a mysql connection using php on a web page, connecting to a mysql table and retrieving the…
Read MoreTweaking RunCloud Servers After Deployment
Here are some references for various fix ups or tweaks that I apply to servers with a RunCloud control panel. These are not all done inclusively, depends on the need. Change root password You root password initially generated by your host provider might be on the weak side always best to change and strengthen it.…
Read MoreRestart Start Stop MySQL Server from Command Line, macOS, Linux
To restart, start or stop MySQL or mariadb database servers from the command line, type the following at the shell prompt… On Linux start/stop/restart from the command line: /etc/init.d/mysqld start /etc/init.d/mysqld stop /etc/init.d/mysqld restart Some Linux flavors offer the service command too service mysqld start service mysqld stop service mysqld restart or service mysql start…
Read MoreSet Up Valet on macOS for Local WordPress Development
This is a guide on how to set up Laravel Valet on macOS for a WordPress local development environment. Using Valet as a WordPress local development solution has the main benefits of speed, being lightweight and using fewer configurations to go wrong than say a solution like Vagrant. There is a 2nd related article that…
Read MoreImport / Export a mysql database on the command line
To export a mysql database (as a dump) from the command line run: mysqldump database_name > database_exportname.sql To import a mysql database dump into a database: mysql database_name < database_exportname.sql To export all databases into a dump: mysqldump –all-databases > all_databases_export.sql To import one of these mysql databases from the dump into a database: mysql…
Read MoreChange and Update WordPress URLS in Database When Site is Moved to new Host
After migrating a WordPress site to a new URL either to a live production site or a testing development server, the new URL strings in the MySQL database need to be changed and updated in the various MySQL database tables. This method just uses the whole MySQL database rather than a WordPress export/import from within and…
Read MoreOptimise wp_postmeta table and remove custom fields meta keys
Overtime a wp_postmeta WordPress database table may become bloated and use redundant custom field meta_keys. The table may have thousands of rows worth of dead data such as old custom fields. You can remove these keys quite quickly in the MySQL database once you know the key format, I recently took over a site that previously…
Read More