Articles of phpmyadmin

Change WordPress Multisite Domain

I created a multisite install on a development domain. Now, I want to change it over to my main domain. I’ve heard that I shouldn’t do a database dump, and change everything with a text editor. I’ve followed the WPEngine tutorial below, but it caused 500 server errors. Any advice? How to change a Multisite […]

Backing up WordPress database and files

I’ve tried a few third party plugins for backing up my site, with some working well and others not so much, so I’m trying out backing up the site manually. Is there anything I’m missing here or is this the proper way to manually back up? In the WordPress folder on FTP copy the following […]

Files on Localhost, Database on Server

With WordPress, is it possible to work on localhost but have the DB on a server? So that workflow will be: 1) Work on localhost (but connected to remote database) 2) Upload JUST files via backup software daily This would eliminate the pain of uploading the database each time (logging into cPanel, dropping DB, uploading […]

Post Views / Hit Counter Problem?

I have decide to use WordPress as a CMS to my 5 moths old website. I have already added all previous posts to my new site ( WordPress ). But now I need to change view counts to previous views counts. I can’t find hit_count or views_count from PhpMyAdmin database. How to change views count […]

SELECT SQL_CALC_FOUND_ROWS with wordpress search

When I make a search on my site no posts are retrieved and through wordpress debug I get this error message: WordPress database error: [Table ‘theme_se.wp_comments‘ doesn’t exist] SELECT SQL_CALC_FOUND_ROWS wp_theme_se_posts.ID FROM wp_theme_se_posts WHERE 1=1 AND ( (wp_posts.post_title LIKE ‘%paradox%’) OR (wp_posts.post_content LIKE ‘%paradox%’) OR EXISTS ( SELECT * FROM wp_comments WHERE comment_post_ID = wp_posts.ID […]

Way to send multiple values for column to MySQL?

I am creating a plugin that allows the user to select multiple options (as a checkbox), which sends these integer values to MySQL. The way I have this set up at the moment is by taking these values and passing them as a comma separate string. Then I take this string, remove the comma’s, and […]

Need to change all links in page content but not in post content

So usually I would just do a database search and replace for changing my URL but what I’ve done now is decided to split my site into two different sites which works great for me because of the way I organized content with pages and posts. All the pages have links going to posts on […]

Changing a Child theme's name on MAMP localhost

I would like to change the child-theme name on my localhost (MAMP) set up for a project I’m working on. Obviously changing the folder name is easy enough, as is changing the child-theme’s name in the comments at the top of the child-theme’s style.css file. How do I change the info in the database / […]

WordPress redirects to old login after migration

I’ve followed all the steps for migrating my existing wordpress site to another server. However, when I try to login to the migrated site, it keeps redirecting me to the old one, despite whether I use wp-admin.php or wp-login.php. I have also read about a dozen different pages on migrating worpress accounts, but not one […]

lost all the links in WordPress after changing hosting

I am moving my wordpress website from one hosting to another. i moved my file(from filesmanager) correctly i export database from phpmyadmin to new host phpmyadmin Home page working fine (http://prophetmuhammadsaw.com) When i click on any post this error occurs [Not Found The requested URL was not found on this server. Additionally, a 404 Not […]