WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Migrating from PDO using SQLite to clean new install using MySQL (3 posts)

  1. cikatomo
    Member
    Posted 1 year ago #

    I've been using PDO plugin for wordpress and SQLite database. It does not work as expected so I want to use MySQL database, but without PDO for WordPress since I cannot trust that plugin anymore, It has not been updated for more than 2 years.

    So, this is what i did:

    Exported SQLite database to sql file
    Made necessary changes in syntax http://www.maxkpage.com/blog/free-sqlite-to-mysql-converter-super-easy/
    Installed new WordPress with new MySQL database
    Copied old Wp-content folder and replaced the new one
    Imported old data by copying all "INSERT INTO ...." form old into new tables, which I emptied first

    Now, here comes the problem. Everything works fine, I can see the posts on website, but when I populate wp_users or wp_usermeta or wp_options with old data I get "You don't have sufficient permissions" message when I log into dashboard. Not wrong username or password, but when I log in I just see that message and the website becomes white blank.

    Where is the problem and how can I fixed it?

  2. cikatomo
    Member
    Posted 1 year ago #

    I found out what is wrong.
    The tutorial says to remove all double quotes " and replace them with spaces or backticks `, but some values in the mentioned tables have double quotes around them. This one for example:

    INSERT INTO "wp_usermeta" VALUES(14,1,'wp_capabilities','a:1:{s:13:"administrator";s:1:"1";}');

    So replacing that with backticks causes malfunction.

    Replace only double quotes around table names "wp_usermeta" -> wp_usermeta

  3. Mjbmr
    Member
    Posted 11 months ago #

Topic Closed

This topic has been closed to new replies.

About this Topic