How to Quickly Update WordPress Code and Database Without a Local or Staging Environment

Managing a WordPress site often means dealing with urgent fixes to your code and database.

While setting up a local environment or staging site is ideal for complex changes, there are times when a quick WordPress code and database fix is the best option.

In this post, we’ll show you how to swiftly handle these updates using cPanel, FTP/SFTP, and other tools. We’ll also cover troubleshooting theme and plugin-related problems to ensure your site runs smoothly.

Table of Contents

When Should You Update Code and Database Directly?

• Urgent Fixes: When a critical issue needs to be addressed immediately.
• Minor Adjustments: Small changes that don’t justify setting up a full local environment.
• Limited Resources: When you don’t have access to a local development setup or prefer not to use one.

Step 1: Quick WordPress Code Fixes Using cPanel or FTP

Using cPanel File Manager

1. Log in to cPanel: Navigate to the File Manager.
2. Locate Your Files: Go to the public_html directory or the root directory where your WordPress files are stored.
3. Edit Files Directly: Right-click on any file (like functions.php or a plugin file) and choose “Edit.” This opens the file in a simple text editor where you can make your changes.

Using FTP/SFTP

1. Install an FTP Client: Download and install an FTP client like FileZilla or Cyberduck.
2. Connect to Your Server: Enter your FTP credentials provided by your host to connect to your server.
3. Navigate and Edit: Browse to the directory containing your WordPress files. Download files to edit locally and then re-upload them, or in some FTP clients, edit files directly on the server.

Quick Code Edits

• functions.php: A common file to edit for adding custom code or temporary fixes. Be careful with syntax errors here, as they can break your site. Always keep a backup.
• Theme and Plugin Files: If a change seems related to your theme or a plugin, edit files within the wp-content/themes or wp-content/plugins directory.

Step 2: Database Fixes Made Simple with phpMyAdmin and SSH

Using phpMyAdmin

1. Log in to phpMyAdmin: Access it from your cPanel or host’s control panel.
2. Select Your Database: Choose your WordPress database from the list.
3. Run SQL Queries: Use the SQL tab to enter and execute queries. For example:

   
                   UPDATE wp_posts
                   SET post_content = REPLACE(post_content, 'Old Text', 'New Text')
                   WHERE post_type = 'post_type_name';
               

   Replace 'Old Text', 'New Text', and 'post_type_name' with your desired values.

Direct SQL Queries via SSH

1. Connect via SSH: Use a terminal or SSH client to connect to your server.
2. Access MySQL: Log in to MySQL by typing:

   
                   mysql -u your_username -p your_database_name
               

3. Run Queries: Execute your SQL commands as needed.

Alternative: Using Adminer for Quick Database Updates

1. Download the Adminer PHP file from Adminer’s official site.
2. Upload it to your WordPress root directory via FTP.
3. Access Adminer through your browser (e.g., yourdomain.com/adminer.php) and log in with your database credentials.
4. Perform updates and delete the Adminer file immediately after use to prevent potential security threats.

Important Notes:

• Always back up your database before executing any SQL commands. Mistakes can lead to irreversible data loss.
• Remove tools like Adminer after use to prevent unauthorized access.

Step 3: Troubleshooting Theme and Plugin Issues

1. Disable Plugins: Temporarily deactivate plugins one by one to identify conflicts. If you can’t access the admin panel, deactivate plugins directly in the database by modifying the active_plugins row in the wp_options table.
2. Check mu-Plugins: Review the wp-content/mu-plugins directory for custom code.
3. Inspect Theme Functions: Review the functions.php file in your active theme for recently added or modified code.
4. Use Advanced Search Tools: Employ IDEs like VS Code or PhpStorm to search for specific functions or problematic code snippets.
5. Review Error Logs: Access server error logs via cPanel or your hosting dashboard for insights.

Updating Plugins and Themes

• Plugin Modifications: Plugins can add filters, actions, or other changes that affect your site. Check plugin files if you suspect issues.
• Custom Code via a Child Theme: If making changes that might be overwritten during updates, create a child theme to preserve modifications.

Wrap Up

Managing WordPress updates directly on a live site can be daunting, but with the right tools and precautions, it’s entirely manageable.

By following the steps in this guide, you can handle urgent fixes, troubleshoot issues, and make bulk updates confidently while minimizing risks.

Always back up your site, prioritize security, and consider testing changes on a staging site whenever possible.