Migrated to Namecheap, now Trouble with Database & wp-config [closed]

You can also use the import/export tools available from wordpress itself. Maybe try a clean
install and import your data from there. It will be a better and more clean migration.

Your import/export Tools will be in Admin->Tools.

If you are looking to import a MySQL database from a MySQL dump, (filename.sql), you can do that from CPanel by going into PHPMyAdmin. From the main screen, go to the Import Tab, browse for your file, and click the “Go” button.

Also, check out this reference to moving WordPress. It’s got some great advice in there as well.
http://codex.wordpress.org/Moving_WordPress

Related Posts:

  1. Restoring WordPress posts from database only
  2. Inserting Post Meta From SQL
  3. How to execute mulitple statement SQL queries using $wpdb->query?
  4. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  5. Query WordPress database by registered date and role
  6. Size article thumbnails and retrieve them directly from database
  7. wpdb_prepare with multiple or condition
  8. SQL Error wp_commentmeta – incorrect table definition
  9. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  10. How do I get the posts within a certain year/date(with sql query)?
  11. Create table from array with prepare
  12. Why this query is not showing any result on wordpresss home page?
  13. Is my way to change WordPress server is correct?
  14. Why does changing Database Table Prefixes result in loss of content?
  15. SQL query to set posts in bulk based on the post content
  16. $wpdb->get_var – What value is returned when zero records are found?
  17. DB prefix not updating
  18. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  19. How to create index (sql) to a meta_key?
  20. Delete all users meta that named: user_avatar
  21. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  22. export individual posts to text files or a single csv file
  23. SQL query : Select a thumbnail for a media
  24. why you don’t Implement PDO for access every thing to database
  25. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  26. Deleting WordPress posts and media files based on author via MYSQL database
  27. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  28. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  29. How do I restore a dump file from mysqldump?
  30. 1052: Column ‘id’ in field list is ambiguous
  31. 1052: Column ‘id’ in field list is ambiguous
  32. difference between primary key and unique key
  33. phpMyAdmin – Error > Incorrect format parameter?
  34. How to do a batch insert in MySQL
  35. Why is my database import losing text widget data?
  36. Please explain how WordPress works with MySQL character set and collation at a low level
  37. How to fetch Data in WordPress using MySQLi or $wpdb
  38. Connect to database using wordpress wp-config file
  39. Reset Post IDs to less than 64bit integer
  40. Does WordPress use the InnoDB engine for MySQL by default?
  41. Display data from a non wordpress database on a page template
  42. Why does dbDelta() not catch MysqlErrors?
  43. Bulk Update of Custom Post Type Post Status through SQL
  44. How do I add indexes to WordPress Database?
  45. Huge wp_options table
  46. what to do when your WordPress database is too large?
  47. Change all http to https in mysql databse?
  48. Block search SQL from happening
  49. WordPress and automated MySQL backups to a different host
  50. Scheduling posts in database
  51. Emojis getting converted to “?”
  52. Uppercase to sentence case for post titles
  53. WordPress database import: Row size too large
  54. Advanced SELECT query with condtional statements
  55. Error establishing database connection – high traffic?
  56. Bulk-create posts from SQL database
  57. Redirecting to old domain after migration website
  58. Migrating to WordPress Recipe Plugin and Some SQL Issues
  59. How to prevent/delay MySQL connections when an object cache is used?
  60. Insert Query not working in the form
  61. “Error establishing a database connection” – Intermittent error on GoDaddy
  62. Error establishing a database connection,
  63. Changing between Local Host DB to Production DB and in reverse
  64. pull data from a remote wordpress database
  65. Clear Terms from Taxonomy for Specific Post IDs?
  66. Options on how to Display member specific data from a MS SQL database
  67. Query Column of Specific ID from Database Table
  68. WP MultiSite: Can’t select database error after changing to new domain
  69. How to connect and insert data in database of wordpress?
  70. Buddypress avatar image in database [closed]
  71. Installing local to live WP into subdirectory
  72. WordPress SQL – How to Check for Category?
  73. Cloning blog to localhost via WAMP
  74. Only allow user to access a link once a year, based on their joining date
  75. Counting post and changing roles in mysql database. Query not code
  76. MSQL database wp_postmeta has meta key tve_revision
  77. Deleting empty meta key values
  78. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  79. “BS_” rows in postmeta table
  80. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  81. What’s the easiest way to connect external database and display data on wordpress?
  82. database error WordPress move from one hosting to other
  83. How to set posts to draft in bulk based on the content of the post
  84. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  85. mySQL database size large, but tables size less
  86. After renaming MySQL database, I can no longer access my Blog page
  87. How To connect to the same WordPress database with different database user
  88. WordPress character set issue
  89. can’t delete a row from post_meta table
  90. Create a new table on the database and save parameters from a contact form
  91. Link wordpress with a SQl + MongoDB + .NET
  92. Why is converting my database to UTF-8 truncating entries?
  93. How to add data from wordpress tables to new database tables you have created
  94. Install WordPress with SQL database
  95. How to back-up a database on IIS
  96. Importing Concrete5 content to WordPress
  97. Weird WP -Cli Error Connection Refused
  98. How to find fresh (last modified) and sql backup?
  99. Understanding Redundant postmeta Tables in WordPress Database
  100. Database table prefix different between wp-config.php and in database