?
Solved

mysql-workbench one export file for many usernames, dbnames

Posted on 2014-03-22
6
Medium Priority
?
392 Views
Last Modified: 2014-03-25
I am learning from a tutorial which has different usernames, different database-names,  same localhost.  Plus I think I did this with another tutorial.

input comes from different (small) .sql files where I copy pasted into windows7 mysql-workbench (lastest 6). Difficult to find all the tutorial code .sql files (but I tested with php and mysql is working)


Can I create one export file where if I lose the data I import restore from one sql file.
I do not want to modify php of tutorial to only have (one username)/ (one dbname)
0
Comment
Question by:rgb192
  • 2
  • 2
  • 2
6 Comments
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39948247
You can export your users' table (mysql/users). Then, on reinstall/move you just import that table.

HTH,
Dan
0
 
LVL 24

Expert Comment

by:mankowitz
ID: 39948612
If you want to save all the tables you are currently working with, Do this from within workbench.

1. Click on "DATA EXPORT" from the Navigator tab.
2. Select all the tables you want to save. (probably all of them).
3. Click on "Export to self-contained file" and then "Start Export".
0
 
LVL 1

Author Comment

by:rgb192
ID: 39948942
data-export

many databases

while there is a
mysql database

there is no users database
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
LVL 35

Accepted Solution

by:
Dan Craciun earned 1000 total points
ID: 39948947
There is a users table, inside the mysql database.

PS: if you don't want to be constrained by Workbench's capabilities, you can use the standard built-in mysqldump: https://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
0
 
LVL 24

Assisted Solution

by:mankowitz
mankowitz earned 1000 total points
ID: 39950049
There is a user table; to see it, do this

select * from mysql.user
0
 
LVL 1

Author Closing Comment

by:rgb192
ID: 39954867
users are listed in mysql database

I will use mysql workbench for now.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question