As more and more developers start to wisen up and develop locally, often a time comes when you just need to grab a bit of sample data for your test database rather than trying to load in a 5GB database onto your local machine. In most cases you can achieve this with a simple mysqldump command. For example to grab the first 100 rows of any tables. CODE mysqldump --opt --where="true LIMIT 100" dbname > dbname.sql scp that over to your local machine and just load it in as you would any normal dump. CODE mysql -uusername -p dbname < dbname.sql For more or less data just change your LIMIT.
|
Last entries
My Blog Links
Last Comments
nsanyi23 on Dump Sample Data with mysqldump
mkaymer on symfony - No colours in command line output mkaymer on How to see which scripts or plugins vim has loaded mkaymer on symfony - No colours in command line output mkaymer on symfony - No colours in command line output mkaymer on QuickForm and Radio buttons mkaymer on symfony - No colours in command line output mkaymer on How to see which scripts or plugins vim has loaded mkaymer on How to see which scripts or plugins vim has loaded mkaymer on How to see which scripts or plugins vim has loaded 0 user(s) viewing
0 guest(s)
0 member(s) 0 anonymous member(s) Search My Blog
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Oct 10 2007, 04:25 PM
Invision Community Blog
1.2.4 © 2010 IPS, Inc.