Migrating from PDO using SQLite to clean new install using MySQL

  • Resolved cikatomo

    (@cikatomo)


    11 years, 10 months 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 https://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?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter cikatomo

    (@cikatomo)

    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

    Working one:

    https://mjbmr.com/blog/en/install-wordpress-with-sqlite

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Migrating from PDO using SQLite to clean new install using MySQL’ is closed to new replies.