title: Splitting MySQL database into tables separate
body: <p>Well I'm not much of a good developer or a database expert. But I have a little understanding of these things. I'm trying to dump a database on a VPS using "mysqldump" command which works perfectly. But when I tried to restore locally after downloading the dump, gives me a time out error.</p>
  
  <p>Can anyone advise me how to dump a database by splitting it into tables separately. The database I'm referring to is pretty large (6 - 7 GB). I actually tried searching and it confuses me.. even this <a href="http://wandzeitung.informations-compagnie.de/2011/07/12/howto-split-a-sql-database-dump-into-table-wise-files/#.UpXTw8QW0Ro" rel="nofollow"><strong>link here</strong></a> confuses me as where to start.</p>
  
  <p>Any help is highly appreciated.</p>