Migrating from PDO using SQLite to clean new install using MySQL

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

Related Posts:

  1. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  2. Migrating database / content of non-CMS site to WordPress
  3. Export all content from wordpress
  4. Trouble Migrating all data blog from WordPress.com to WordPress.org
  5. Migration: Copying database content to a different server
  6. Image link issues after importing a database backup to my local web server
  7. Database create or redirect
  8. Importing Concrete5 content to WordPress
  9. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  10. Rename a table in MySQL
  11. How should I tackle –secure-file-priv in MySQL?
  12. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  13. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  14. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  15. MySQL SELECT increment counter
  16. phpMyAdmin – Error > Incorrect format parameter?
  17. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  18. Using wpdb to connect to a separate database
  19. MySQL Database User: Which Privileges are needed?
  20. Why is my database import losing text widget data?
  21. Multiple developers / editors working on a site in progress
  22. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  23. Will it break my site if I delete all transient records in wp_options table?
  24. Checking if Database Table exists
  25. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  26. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  27. Please explain how WordPress works with MySQL character set and collation at a low level
  28. Solution for database version control and deployment?
  29. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  30. How to fetch Data in WordPress using MySQLi or $wpdb
  31. WordPress Database lost auto increment
  32. Connect to database using wordpress wp-config file
  33. wpdb->insert multiple record at once
  34. How to migrate a HTTPS WordPress installation to localhost?
  35. Reset Post IDs to less than 64bit integer
  36. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  37. Restoring WordPress posts from database only
  38. WordPress database scalability from the code perspective
  39. How to define composite keys with dbDelta()
  40. Is it possible to define two databases for one installation?
  41. Does WordPress use the InnoDB engine for MySQL by default?
  42. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  43. Slow wp_term_relationships query
  44. How to use “TRUNCATE TABLE” MySQL statement?
  45. Can I use MariaDB instead of MySQL in wordpress?
  46. Migrating data between local and development server
  47. Best way to import users, post and categories from an external database
  48. Syncing local content with development / staging sites
  49. Organizing WP Pages based on old website database
  50. Presentation vs Content in WP DB-Tables
  51. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  52. WordPress for a very large website
  53. What are conventions about the schema of the $table_prefix
  54. Split WP install between 2 databases?
  55. Inserting Post Meta From SQL
  56. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  57. Why does dbDelta() not catch MysqlErrors?
  58. Migrate a Non WordPress database to wordpress [closed]
  59. Is deleting orphaned wp_options entries safe?
  60. Is altering a default WordPress database table update safe?
  61. How to solve slow WordPress site caused by attachment_metadata
  62. Huge wp_options table
  63. “MySQL server has gone away” since update to 3.8
  64. Sub-domain or 2nd, temporary different domain?
  65. Cloning and syncing a WordPress website
  66. Delete all post meta except featured image
  67. WordPress showing install screen after max_questions error
  68. Custom DB_COLLATE (collation) value not working on fresh install?
  69. What causes the “max_user_connections” warning on WordPress frontend?
  70. what to do when your WordPress database is too large?
  71. Change all http to https in mysql databse?
  72. WooCommerce – Query for ordered products
  73. Large database causes slow load
  74. Error establishing a database connection – with Debug Data
  75. How to execute mulitple statement SQL queries using $wpdb->query?
  76. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  77. Database slowdown after update to 3.4.1
  78. Can I transfer a mysql database to another site?
  79. WordPress and automated MySQL backups to a different host
  80. Database with mixed collation (utf8mb4 & utf8_general_ci)
  81. Query WordPress database by registered date and role
  82. MySQL Syntax Error upon restoring database from backup [closed]
  83. Tons of Twitter rows in my database
  84. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  85. How to insert data into MySQL database from the form created in WordPress site
  86. Installation with sql server express edition
  87. Set Display Name to first and last name (phpmyadmin SQL Query)
  88. Weird issue with database migration and SSL links
  89. Size article thumbnails and retrieve them directly from database
  90. How to fix unchanged URLs in Database after running serialized search and replace script?
  91. WordPress site uses MyISAM, should I switch to InnoDB necessary?
  92. Is it safe to convert tables from MyISAM to InnoDB?
  93. Emojis getting converted to “?”
  94. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  95. How do I reset a self-hosted WordPress URL?
  96. Does WordPress ever need multiple databases?
  97. Why are no posts showing despite my apparently correct DB restoration?
  98. Select Multiple meta_value from WP DB; Single Query
  99. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  100. Delete all post meta except featured image Using SQL
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)