Mysql : dump database along data

by 
backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

This will do,

If your requirement is to dump data alone then go for this,

To export to file (data only)

mysqldump -u [user] -p[pass] --no-create-db --no-create-info mydb > mydb.sql

Related Contents:

  1. How can I convert an MDB (Access) file to MySQL (or plain SQL file)?
  2. How do I import an SQL file using the command line in MySQL?
  3. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  4. SQL select only rows with max value on a column [duplicate]
  5. ROW_NUMBER() in MySQL
  6. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  7. MySQL CONCAT returns NULL if any field contain NULL
  8. “where 1=1” statement [duplicate]
  9. UPDATE multiple rows with different values in one query in MySQL
  10. MySQL Like multiple values
  11. Ordering by the order of values in a SQL IN() clause
  12. Unknown column in ‘field list’ error on MySQL Update query
  13. Convert partially non-numeric text into number in MySQL query
  14. Generating a random & unique 8 character string using MySQL
  15. Using DISTINCT and COUNT together in a MySQL Query
  16. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  17. MySQL Query to select data from last week?
  18. Replace Default Null Values Returned From Left Outer Join
  19. MySQL DELETE FROM with subquery as condition
  20. How to insert data to MySQL with auto-incremented column(field)?
  21. How to remove unique key from mysql table
  22. Combining UNION and LIMIT operations in MySQL query
  23. How to round down to nearest integer in MySQL?
  24. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  25. Strip last two characters of a column in MySQL
  26. MySQL: How to insert a record for each result in a SQL query?
  27. #1025 – Error on rename of ‘./database/#sql-2e0f_1254ba7’ to ‘./database/table’ (errno: 150)
  28. Use LIKE %..% with field values in MySQL
  29. GROUP BY having MAX date
  30. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  31. How to count the number of instances of each foreign-key ID in a table?
  32. mysql SELECT IF statement with OR
  33. SQL SELECT LIKE (Insensitive casing)
  34. Drop MySQL databases matching some wildcard?
  35. How to insert columns at a specific position in existing table?
  36. MySQL order by “best match”
  37. MySQL: View with Subquery in the FROM Clause Limitation
  38. Insert and set value with max()+1 problems
  39. mysql count group by having
  40. Setting value for one column of all records in table
  41. How do I count columns of a table
  42. How do I generate a SQL script from my diagram in MySQL Workbench?
  43. How to get list of dates between two dates in mysql select query [duplicate]
  44. updating columns with a sequence number mysql
  45. When running UPDATE … datetime = NOW(); will all rows updated have the same date/time?
  46. MySQL export into outfile : CSV escaping chars
  47. How to SUM and SUBTRACT using SQL?
  48. SQL query to prepend prefix to existing value in a field
  49. MAX function in where clause mysql [duplicate]
  50. Dump File MySQL 5.6.10

Leave a Comment