After Import: Insert “Use” Statement in Database

It appears, at least in cPanel, the lines in question were not required in the export, with the unsurprising consequence of the other encapsulated sql statements defaulting to reference the current database only.

Turns out to be convenient when more than one database is configured, so long as there are no statements that select objects from other databases (untested).

Related Posts:

  1. Export SQL query based on custom field?
  2. How do I import an SQL file using the command line in MySQL?
  3. Setting up foreign keys in phpMyAdmin?
  4. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  5. MySQL Error #1133 – Can’t find any matching row in the user table
  6. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  7. How to create a foreign key in phpmyadmin
  8. importing a CSV into phpmyadmin
  9. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  10. What specific database privileges does WordPress need?
  11. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  12. How to copy post titles to post slug in phpmyadmin
  13. How to do a MySQL dump from production site without using a search and replace script for local development?
  14. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  15. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  16. Error while importing database
  17. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  18. Unknown collation when I import a dump from an existing site into a development database?
  19. Can’t find my wordpress DB in phpmyadmin
  20. WordPress database import: Row size too large
  21. Backing up and restoring multiple sites efficiently
  22. $wpdb to insert html form information
  23. Create a form with custom autocomplete address field and CSV import values
  24. Setting up WordPress Locally on WAMP for a new site (with one already)
  25. Getting Error Trying to Create Table
  26. Export Yoast Keywords from MySQL/phpMyAdmin
  27. Editing mysql tables/database with wordpress or other app/cms
  28. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  29. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  30. Exporting completed webiste for another server
  31. List users with the most posts in the last 30 days
  32. latency problems with wordpress install (from SQL import)
  33. Mysql Server keeps crashing
  34. How to bulk delete a certain part of all wordpress posts
  35. When I add metadata, metavalue length is added in to the value in some cases
  36. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  37. Find locations of all featured images of draft posts via SQL
  38. SQL query to change custom field in WordPress database
  39. An SQL query to find orphaned image attachments and their meta
  40. Weird characters displayed when importing WordPress MySQL db
  41. cannot log in to the mysql server (wamp and wordpress)
  42. SQL command to export post_content from wp_posts using phpMyAdmin
  43. Need SQL query to find&replace image URL
  44. How do I load a sql.gz file to my database? (importing)
  45. MySQL error 2006: mysql server has gone away
  46. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  47. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  48. How to get size of mysql database?
  49. SQL – Update multiple records in one query
  50. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  51. mysqladmin: connect to server at ‘localhost’ failed
  52. mysql update multiple columns with same now()
  53. Generating a random & unique 8 character string using MySQL
  54. MySQL > Table doesn’t exist. But it does (or it should)
  55. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  56. Can’t create test file lower test start server mysql
  57. MySQL delete multiple rows in one query conditions unique to each row
  58. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  59. CAST to DECIMAL in MySQL
  60. Failed to Connect to MySQL at localhost:3306 with user root
  61. Moving WordPress from MAMP to WAMP, can’t access pages
  62. How do you properly prepare a %LIKE% SQL statement?
  63. SQL query to update post_date (one post = one single date & time)
  64. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  65. Database: Custom table: sprintf value for DateTime column
  66. Query to change custom post type with specific category
  67. WP_USE_EXT_MYSQL
  68. Distinction on meta value on pre_get_posts
  69. Query to import data from one MultiSite table to another (pages/sub-pages)
  70. MySQL Rank & $wpdb
  71. How to display data from custom table in wordpress phpmyadmin
  72. WordPress post_status is future, manually added
  73. How are multiple WordPress WPDB queries handled?
  74. Will changing the folder name two directories above a fresh wordpress installation break the site?
  75. Regarding “Insert query error” in wordpress
  76. WordPress plugin overloading with tmp tables
  77. Site not responding error – taking long to load [closed]
  78. WordPress(wpdb class) and mysql stored procedures
  79. WordPress plugins for database queries
  80. WordPress doesn’t display accents after migration
  81. Broken wordpress site, non-working links and no access to wp-admin page
  82. Replace a character in all post titles and slugs
  83. Understanding custom php that reads from WP MYSQL
  84. $wpdb->get_var multiple queries in one database check
  85. Way to extract wordpress data from folder backup
  86. Data is not constatntly loading from custom wordpress table
  87. How to search usermeta table
  88. How to add virtual column in wpdb get_result statement
  89. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  90. I want to share local developement and staging DB — Is this very smart or very stupid?
  91. Extract all users along with yoast metadata description
  92. Featured image from custom to WordPress database
  93. WordPress asks to install, but is already installed?
  94. Deleting a table row through query
  95. Simple SQL Query in wordpress
  96. optimise SQL wordpress call
  97. WP_Query with LIKE returns strange query
  98. How to find source of these strange SQL queries?
  99. How to reduce uncached page generation time?
  100. Do Seeded Orderby Rand Queries Benefit from DB Caching?