Solved

mysql-workbench one export file for many usernames, dbnames

Posted on 2014-03-22
6
383 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
 

Author Comment

by:rgb192
ID: 39948942
data-export

many databases

while there is a
mysql database

there is no users database
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 35

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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 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