The copy performances are also great, to the point that this command can be also used to do regular backups. We can choose to copy only the DB structures (empty tables) or structure + data: if we choose to copy the data, we can also manually select which tables, views, stored procedures, functions, triggers and/or events to copy. A powerful command that allows us to copy any source database to any destination database, even if they’re on different MySQL servers, as long as we’re connected to both of them. Copy Database to different Host/Database.The query editor isn’t the only thing that SQLyog can do: here’s a brief list of the features I love the most, mostly because they saved me a lot of precious time in a number of occasions: Once connected we’ll be able to write and send our own queries, just like the Connection Panel shipped with the MySQL Workbench but – at least in my opinion – with a better editor and a superior syntax highlighting. It also features a practical Address Book, very similar to the one available in client softwares such as FileZilla or TeamSpeak: we can use it to create entries that, once added, will allow us to connect to the destination server with a single mouse click. The GUI interface is what makes SQLyog great: simple, clear and finely tailored around the developer’s needs. The SQLyog GUI is simple and clear, showing just what we need in an optimized way.
#SIMPLE GUI FOR MYSQL DATABASE OR ACCESS DB SOFTWARE#
However, there’s a still rather unknown alternative that we can use instead of the aforementioned Workbench – or, even better, together with it: we’re talking about SQLyog, a small yet great piece of software developed by Webyog and available in multiple editions: Enterprise, which is available through Trialware and shipped with many useful administrative modules for IT experts and business companies, and also Community, mostly aimed to software developers and free for personal use.
We’re talking of a bunch of great features that will cover most – if not all – the requirements of any decent MySQL developer and/or administrator: if you want to get a solid grip of your MySQL servers, installing the MySQL Workbench on your development machine is almost always a good choice.
0 kommentar(er)
