mysqldump -u root -p --opt --where="1 limit 100" database_name > new_database_name.sql // dump 100 record of every table
scp username@server_id_address_or_name:path/to/file /path/to/local/pc
Created
February 27, 2020 05:35
-
-
Save sujancse/dc9e12fc6d799dbb7e830319cb3ed3dd to your computer and use it in GitHub Desktop.
mysqldump limited data from server
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment