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. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  27. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  28. MySQL SELECT increment counter
  29. how to drop partition without dropping data in MySQL?
  30. Creating a search form in PHP to search a database?
  31. MySQL equivalent of DECODE function in Oracle
  32. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  33. WordPress Database lost auto increment
  34. wpdb->insert multiple record at once
  35. Getting wrong relationship value in $args in wp_Query?
  36. Slow wp_term_relationships query
  37. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  38. How to use “TRUNCATE TABLE” MySQL statement?
  39. Organizing WP Pages based on old website database
  40. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  41. What are conventions about the schema of the $table_prefix
  42. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  43. Is deleting orphaned wp_options entries safe?
  44. How to solve slow WordPress site caused by attachment_metadata
  45. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  46. Delete all post meta except featured image
  47. WooCommerce – Query for ordered products
  48. Large database causes slow load
  49. Database slowdown after update to 3.4.1
  50. Tons of Twitter rows in my database
  51. How to insert data into MySQL database from the form created in WordPress site
  52. Select Multiple meta_value from WP DB; Single Query
  53. Which is more efficient? Using usermeta, or creating a new MySQL table?
  54. How do I copy a wordpress database?
  55. Is it possible to split database tables using HyperDB?
  56. What happens if I overwrite the current wp_options table with a backup from a week ago?
  57. CRUD operations using WordPress database API
  58. Handling large N data in WordPress
  59. How to Mirror WordPress database from Remote server to Local server
  60. WordPress is not creating table in database after activating plugin,
  61. Is MariaDB’s Aria storage engine suitable for WordPress?
  62. Difficulty importing my live site to local
  63. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  64. A MySQL DB within a MySQL DB
  65. How do I query wp_options for expired transient pairs with MySQL commands?
  66. Is there a way to recover the table wp_term_relationships?
  67. Trouble Migrating all data blog from WordPress.com to WordPress.org
  68. WordPress running SQL query to update database from form
  69. How to fix database error duplicate entry
  70. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  71. WPDB SQL query with prepare() returning variable, not db value
  72. Query multiple tables at once?
  73. Problems with moving my WordPress site to another domain/server
  74. Best practice to limit results in get_row()?
  75. How to migrate a database from a server to another
  76. Trouble running $wpdb->query() with last_insert_id
  77. Delete all posts that do NOT have a specific tag
  78. Moving WordPress site to new domain – database import [duplicate]
  79. Location of WP default mySQL tables creation file?
  80. Changing order of db results when encoding to JSON
  81. How to display data from db in select list [closed]
  82. Link multiple user databases together?
  83. How can I find user role in Mysql?
  84. Bulk find & replace on WordPress posts/pages (minus image paths)
  85. How do I loop/iterate through posts to edit all img tags?
  86. Where is the HTML-handler part in the wpdb class?
  87. Featured image from custom to WordPress database
  88. WordPress Database Query works in phpMyAdmin but not in the code
  89. Correct and secure way to access a custom SQL database in a custom PHP template file
  90. How to retrieve user data based on role using SQL?
  91. spambot registering without providing email or password, bypassing registration process
  92. Possible to restore wordpress database from mysql56 and sqlite files?
  93. Missing latest posts and options after DB migration via phpMyAdmin
  94. Widgets with *internal* links do not display after database migration
  95. How do i get value from wp_postmeta?
  96. “MySQL server has gone away” since update to 3.8
  97. featured image not showing up with mysql_connect
  98. Getting deleted users in database
  99. trying to install wp but i have no clue on hosting and servers [closed]
  100. How to find fresh (last modified) and sql backup?