Solved

mysql-workbench one export file for many usernames, dbnames

Posted on 2014-03-22
6
368 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 34

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
 

Author Comment

by:rgb192
ID: 39948942
data-export

many databases

while there is a
mysql database

there is no users database
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 34

Accepted Solution

by:
Dan Craciun earned 250 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 250 total points
ID: 39950049
There is a user table; to see it, do this

select * from mysql.user
0
 

Author Closing Comment

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

I will use mysql workbench for now.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Creating and Managing Databases with phpMyAdmin in cPanel.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now