<div>
thank you,<br />
I tried the workbench link and done the export.<br />
after it finished I opened the file location and I see all the backed up &quot;MySQL&quot; tables in a (.sql) format! When I double click on them, SQLserver opens with the query window of that backup. does that make sense?! They should really open with Mysql.<br />
<br />
<br />
<br />
<br />
thanks.
</div>


thank you,
I tried the workbench link and done the export.
after it finished I opened the file location and I see all the backed up "MySQL" tables in a (.sql) format! When I double click on them, SQLserver opens with the query window of that backup. does that make sense?! They should really open with Mysql.




thanks.

<div>
<div class="content wysiwyg-content">
Hello:<br />
I just need to take a one time Full bakcup of a MySQL database. I dont know PHP and Linux or all the there LAMP stack utilities.<br />
I am a SQL server DBA and just needs to ensure I back up a small database in MySQL workbench.<br />
<br />
Is there any gui inteface to take that small backup?<br />
I looked up online and many suggestions go to the route of PHP and other command line ways, but I am looking for a gui from the Workbench, something like r-click , tasks, bakcup (like in SSMS)<br />
<br />
Thank you.
</div>
</div>


Hello:
I just need to take a one time Full bakcup of a MySQL database. I dont know PHP and Linux or all the there LAMP stack utilities.
I am a SQL server DBA and just needs to ensure I back up a small database in MySQL workbench.

Is there any gui inteface to take that small backup?
I looked up online and many suggestions go to the route of PHP and other command line ways, but I am looking for a gui from the Workbench, something like r-click , tasks, bakcup (like in SSMS)

Thank you.

How do you take a Full back up in MySQL (as like in SQL server via SSMS)

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

The Apache HTTP Server is a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards. Typically Apache is run on a Unix-like operating system, but it is available for a wide variety of operating systems, including Linux, Novell NetWare, Mac OS-X and Windows. Released under the Apache License, Apache is open-source software.