![]() After the first run, you can switch it to update or none. We’ll talk about that in a future article. You must begin with either create or update, because you do not yet have the database structure. On the next page, youll have a choice of installers to download: web installer: The web installer is a smaller initial download. Visit the MySQL download page to find a link to the installer: Click MySQL Installer for Windows. As you might have guessed, you use that link to restore a locally stored backup up to the MySQL server here at Winhost. The MySQL project provides a native Windows installer to install and configure your database. Your database is backed up for development use or simply for safe keeping.īut check out the “Data Import/Restore” link right under the “Data Export” link. If everything goes according to plan you’ll see the “Export competed” dialog, and you’ll be all set. That’s where your backup(s) will be located. Choose “Export to Self-Contained File” and make note of the path.Select your database in the “Tables to Export” window.But as you can see, you can do a lot more than just a simple database dump here. For the purposes of this how-to we’re just making a simple backup of the entire existing database, so we’re not going to use most of those options. ![]() There are a lot of options on the next screen. Go ahead and close that, and click the connection that you just set up. NOTE: Databases are called schemas in MySQL. The Create New Server Instance Profile wizard will be displayed. If everything is correct you’ll see the successful connection box. DOUBLE-Click on your MySQL instance under the SQL Development section of Workbench to create a new schema. From the Home screen of MySQL Workbench, click New Server Instance. Click “Store in Vault” to enter your database password.Enter the MySQL server hostname (you can find that in the MySQL Manager in Control Panel).Click the + icon to open the new connection window.Download MySQL Workbench here (you’ll need a free Oracle account if you don’t already have one – just click the “Register” link in the upper right corner of that download page).įirst thing you’ll need to do in Workbench is connect to your database. Version 6.3.7 is shown here, and of course future versions may differ. Allow us to save you some time with these simple instructions. Making a backup in MySQL workbench is a pretty easy task once you know what to do, but it can be a little confusing the first time around. It’s easy, it’s inexpensive and it’s cool. Read about it on our site, or activate it in Control Panel. Note: The manual methods in this tutorial are great, but if you’re looking for a “set-it-and-forget-it” automated backup solution, we offer a site backup service that can also back up your MS SQL and MySQL databases.
0 Comments
Leave a Reply. |