Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forums | Webyog

Tools to manage and monitor MySQL databases

Improve Mysql Database Export (Sql Dump) Performance For Medium And La

This topic is empty.

Viewing 3 reply threads

Author

Posts
- January 20, 2012 at 1:58 pm #12574
  
  x9sim9
  Member
  
  One issue I am having is how much slower it is to do a database export from SQLYog (SQL Dump) is compared with PHPMyAdmins export function. I've found it to be at least 10 times slower even when the database is on the local network rather than the internet.
  
  At the moment I am exporting using PHPMyAdmin and then importing with SQLYog which is alot faster but a bit tedious.
- January 20, 2012 at 3:02 pm #33077
  
  peterlaursen
  Participant
  
  Are phpMyAdmin and SQLyog installed on same machine? You only tell 'same network' not same machine.
  
  We did some benchmarks between mysqldump and SQLyog a few years back and they have same speed within a margin of a few percent.
- January 20, 2012 at 3:06 pm #33078
  
  peterlaursen
  Participant
  
  Btw: why is it 'tedious' to import with SQLyog? Do you do from tools .. execute sql script -menu? You should not open the file in the editor if you just want to import it.
- February 2, 2012 at 5:22 pm #33079
  
  x9sim9
  Member
  
  'peterlaursen' wrote:
  
  Btw: why is it 'tedious' to import with SQLyog? Do you do from tools .. execute sql script -menu? You should not open the file in the editor if you just want to import it.
  
  It wasn't the import that was tedious it was the switching between phpmyadmin and sqlyog which I was finding tedious.
  
  The phpmyadmin function is on the remote server, whilst the sqlyog is on the local machine. Performance is significatly slower
Author

Posts

Viewing 3 reply threads

You must be logged in to reply to this topic.