Questions about any and all tools related to databases or the job of database administration.

learn more… | top users | synonyms

0
votes
0answers
38 views

How to solve MySQL Utilities Error: Server is offline?

I've been working on a MySQL Server 5.7 Community Edition and I would like to use MySQL utilities. I've installed MySQL Connector/Python and MySQL Utilities, both from source. I've checked MySQL ...
0
votes
0answers
22 views

Efficient import of 1 million SQL files in Postgresql

I have a huge problem. I have 1 million SQL files varying in size from 9KB to 3MB that I need to import into one table very quickly. The files represent hundreds of billions of rows. Is there a ...
0
votes
0answers
3k views

Generating an ER Diagram from SQL CREATE TABLE statements

As I can't find any ER diagram feature built in with Apex, I want to create one with the SQL statements I executed in order to set up the tables in my Apex Workbench. I found schemaSpy, which is ...