how to create mysql database backup file in windows [closed]

by

U can use this:

mysqldump -u username -p databasename > filename.sql to export

mysql -u username -p databasename < filename.sql to import

More Related Contents:

  1. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  2. WHERE vs HAVING
  3. How to do Inheritance Modeling in Relational Databases?
  4. MySQL error 1449: The user specified as a definer does not exist
  5. MySQL – UPDATE query with LIMIT
  6. Differences between utf8 and latin1
  7. phpMyAdmin on MySQL 8.0 [duplicate]
  8. Change decimal separator in MySQL
  9. SQL query of multiple values in one cell
  10. Fetching linked list in MySQL database
  11. How to skip certain database tables with mysqldump?
  12. Using MySql with Entity Framework 4 and the Code-First Development CTP
  13. How can I correct MySQL Load Error
  14. Using ALTER to drop a column if it exists in MySQL
  15. Count number of unique values
  16. ‘Access denied for user ‘root’@’localhost’ (using password: NO)’
  17. MySQL treats ÅÄÖ as AAO?
  18. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  19. Count with IF condition in MySQL query
  20. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  21. Mysql select where not in table
  22. How to format number with “.” as thousands separator and “,” as decimal separator?
  23. Using DISTINCT and COUNT together in a MySQL Query
  24. Which DATATYPE is better to use TEXT or VARCHAR?
  25. Error installing mysqlclient for python on Ubuntu 18.04
  26. MySQL OPTIMIZE all tables?
  27. What’s mysql’s “BETWEEN” performance over..?
  28. MySQL: set field default value to other column
  29. Deleting a row based on the max value
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment