dumping mysql database ignoring some tables
Mysql comes with a handy tool for dumping database, like from remote server to local machine or vice versa.
Sometimes you might want to dump some tables but not the other here you go!
mysqldump -h[HOST] -u[USERNAME] --port=[PORT] -p --ignore [ignoretablename] databasename > databasename.sql
The database.sql would contain all the schema + data.
Then import it as
mysql -h[host] -u[username] -p databasename < databasename.sql
You can provide -p[password] or if you leave it as -p you would be prompted for password later which is a cool way to proceed.
ENJomYsql!
See how you would solve these known algorithm problems
Implement Queue Using two Stacks – JavaScript algorithmCheck if there are three numbers a, b, c giving a total T from array A
Changing decimal number to its binary equivalent
Check if two strings are anagrams or not
find longest word in the sentence
Array reversal in Recurrsion
Find K Complementary numbers from array Java implementation
Find the pairs that makes K Complementary in the given array java solution
Flatten nested javascript array
Java solution for checking anagram strings – tell if phrases are anagrams