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. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  27. Deleting WordPress posts and media files based on author via MYSQL database
  28. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  29. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  30. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  31. Rename a table in MySQL
  32. How should I tackle –secure-file-priv in MySQL?
  33. What is “Advanced” SQL?
  34. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  35. Case statement in MySQL
  36. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  37. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  38. How do I restore a dump file from mysqldump?
  39. MySQL SELECT increment counter
  40. Error Code: 2013. Lost connection to MySQL server during query
  41. how to drop partition without dropping data in MySQL?
  42. 1052: Column ‘id’ in field list is ambiguous
  43. 1052: Column ‘id’ in field list is ambiguous
  44. difference between primary key and unique key
  45. Creating a search form in PHP to search a database?
  46. Oracle SQL query for Date format
  47. phpMyAdmin – Error > Incorrect format parameter?
  48. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  49. MySQL equivalent of DECODE function in Oracle
  50. How to do a batch insert in MySQL
  51. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  52. Using wpdb to connect to a separate database
  53. MySQL Database User: Which Privileges are needed?
  54. Why is my database import losing text widget data?
  55. WPDB Insert or if exists Update
  56. Will it break my site if I delete all transient records in wp_options table?
  57. Checking if Database Table exists
  58. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  59. Please explain how WordPress works with MySQL character set and collation at a low level
  60. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  61. How to fetch Data in WordPress using MySQLi or $wpdb
  62. WordPress Database lost auto increment
  63. Connect to database using wordpress wp-config file
  64. wpdb->insert multiple record at once
  65. Reset Post IDs to less than 64bit integer
  66. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  67. WordPress database scalability from the code perspective
  68. How to define composite keys with dbDelta()
  69. Is it possible to define two databases for one installation?
  70. Does WordPress use the InnoDB engine for MySQL by default?
  71. Where are image paths to product category images stored in WordPress database
  72. Getting wrong relationship value in $args in wp_Query?
  73. Slow wp_term_relationships query
  74. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  75. How to use “TRUNCATE TABLE” MySQL statement?
  76. Sharing database for collaborative development
  77. Can I use MariaDB instead of MySQL in wordpress?
  78. Display data from a non wordpress database on a page template
  79. Organizing WP Pages based on old website database
  80. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  81. WordPress for a very large website
  82. What are conventions about the schema of the $table_prefix
  83. Split WP install between 2 databases?
  84. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  85. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  86. How to Join two tables from separate databases within WordPress
  87. Why does dbDelta() not catch MysqlErrors?
  88. Bulk Update of Custom Post Type Post Status through SQL
  89. How do I add indexes to WordPress Database?
  90. Moving an entire wordpress site from one domain to a new domain and database
  91. Is deleting orphaned wp_options entries safe?
  92. Is altering a default WordPress database table update safe?
  93. How to solve slow WordPress site caused by attachment_metadata
  94. Huge wp_options table
  95. “MySQL server has gone away” since update to 3.8
  96. Change SQL get_results to search for posts with custom term in custom taxonomy
  97. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  98. Delete all post meta except featured image
  99. Custom DB_COLLATE (collation) value not working on fresh install?
  100. What causes the “max_user_connections” warning on WordPress frontend?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)