Database Name Change

Ok…

So after some more research I found: http://andrewapeterson.com/2012/08/fix-wordpress-media-library-and-attachments-broken-after-movingcloning-site/ which explains that you can’t just do a find and replace in a text editor and be good to go.

Fortunately, I still had the original database, so I dropped all the tables in the tsi_ database and restored the original wp_ database.

All my images were restored and the site was back to normal, now to change the database prefix properly…

I found a plugin called Change DB Prefix: https://wordpress.org/plugins/db-prefix-change/ it allows you to put in the old prefix wp_ and replace it with a new one tsi_.

The plugin safely changed my database prefix and updated my wp_config file in less than a second! All my images are fine and everything is now up and running correctly with the new database prefix!!

Hope this helps someone!

Thanks,
Josh

Related Posts:

  1. Media Library doesn’t allow uploads? Upload Directory
  2. Media library images “missing” after migrating them using SQL
  3. Media Library won’t recognize SOME old files after move
  4. Many images in wp-content/uploads folder that are not in Media Library
  5. How do you query for “is not null” in Mongo?
  6. What is a file based database?
  7. Multiple developers / editors working on a site in progress
  8. What’s the simplest way to backup my WordPress database?
  9. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  10. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  11. Solution for database version control and deployment?
  12. How to integrate custom database table in WordPress and using WordPress functions
  13. delete_option() and update_option() returning false
  14. How to change option recently_edited?
  15. How to initialize $wpdb?
  16. Organizing WP Pages based on old website database
  17. When importing database, it shows error
  18. How to close wpdb connection? [duplicate]
  19. Why is Woocommerce writing in my wp_comment table?
  20. save new data to wp_options non-post form
  21. Error establishing a database connection when migrating site to localhost
  22. How to implement content from external database into WordPress text page? [closed]
  23. Strange characters on wordpress site – Not UTF8 Issue
  24. WordPress showing install screen after max_questions error
  25. Connect to live db whilst working locally
  26. Storing textbox values in Database
  27. Why do wordpress store pages/posts within the database instead of files? [closed]
  28. Insert custom data to custom table on wordpress database
  29. How does WordPress store data?
  30. Query WordPress database by registered date and role
  31. Tons of Twitter rows in my database
  32. Merging WordPress posts from different databases
  33. Why can’t I swap a DB in a WP install? [closed]
  34. How to replace values in WordPress DB using phpMyAdmin
  35. How do I reset a self-hosted WordPress URL?
  36. Show content from database
  37. Customize JSON output
  38. CRUD operations using WordPress database API
  39. Display SQL that wordpress is running
  40. change wp user status from wp_users table
  41. How to resolve Connections using insecure transport are prohibited while –require_secure_transport=ON
  42. Is MariaDB’s Aria storage engine suitable for WordPress?
  43. Difficulty importing my live site to local
  44. WordPress returns to an old version
  45. Super slow queries from author archive pages killing my database
  46. localize elements in database
  47. WordPress running SQL query to update database from form
  48. How to fix database error duplicate entry
  49. WPDB SQL query with prepare() returning variable, not db value
  50. Get value form wordpress database
  51. Moving to another server database connection error [closed]
  52. Why this query is not showing any result on wordpresss home page?
  53. Best practice to limit results in get_row()?
  54. How to display content from external db with relevant urls
  55. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  56. Connect to another WP install and grab post based on custom field
  57. Which table (and column) has the content of configured get_post_meta?
  58. Serialize data before inserting into the DB
  59. Pages from custom table
  60. content disappearing minutes after it’s published
  61. What is the most efficient way to reset a WordPress site?
  62. Add pdf to a website
  63. Optimizing function that automatically creates internal links based on post title string
  64. WordPress where clauses in db select
  65. How to display data from db in select list [closed]
  66. Will adding & modifying default WordPress table index break future WordPress update
  67. echo site_url() returns a different value than what is in the database siteurl field
  68. Native timestamp on wp_options option
  69. _wp_attachment_metadata is not being added to database when PDF files uploaded
  70. SELECT rows between two datetimes when the range is dynamic [closed]
  71. How do I loop/iterate through posts to edit all img tags?
  72. error establishing a database connection 3
  73. How to edit posts/pages without making the change live?
  74. Correct and secure way to access a custom SQL database in a custom PHP template file
  75. How to optimise this database query?
  76. How to retrieve user data based on role using SQL?
  77. Does WordPress Support Using Named Pipes on the Windows Operating System?
  78. Missing latest posts and options after DB migration via phpMyAdmin
  79. Store id from database query in cookie
  80. Split database on large site?
  81. Store the wordpress “featured image” under »wp_posts« Database table
  82. Custom metabox does not store data
  83. What WordPress file is saving new users to database
  84. wordpress database error
  85. How do i get value from wp_postmeta?
  86. Local host to server import problem
  87. Author ID mismatch from database
  88. MySQL Database User: Which Privileges are needed?
  89. Import Excel (or csv) Table with user-data as subscribers to wordpress
  90. Automatic add record after refreshing page
  91. Recommended Post Structure for DB Storage
  92. SQL query : Select a thumbnail for a media
  93. trying to install wp but i have no clue on hosting and servers [closed]
  94. What is table `wp_woocommerce_termmeta` for? [closed]
  95. WordPress API standard compliance and specification for external database [closed]
  96. Theme Options – localhost to new url
  97. wp_usermeta key problem
  98. How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
  99. Database Queries are crashing the server
  100. Uploading to WordPress Database