I am trying to connect a db thats hosted on cloud, i have url something like test.db.prod.company.com But in workbench connection popup asks for port as well.
I have MySQL Workbench client installed on my laptop and it's connected to a MySQL database in the cloud. What's the easiest way for me to bring down a copy of the remote database to my laptop? I'm open to a 2-step process where I bring down the database DDL scripts first and then bring down related database data insert scripts.
Hi there! I'm pretty new here, I am trying to export a table I imported via csv so that I can use it on my programming language.
But when I try to export it seems to not contain any table at all. maybe I am doing something wrong?
https://i.imgur.com/K5jfhSS.png
and this is what shows after I try to open the .sql
https://i.imgur.com/JRcEJzB.png
https://i.imgur.com/BK2xBgw.png
my table is supposed to contain over 6k rows and 6-8 columns
and this error shows https://i.imgur.com/2BSGTZz.png after I try to connect to it.
thanks for the help!
I run a record label where I have to handle a stupid amount of royalty payments to hundreds of clients, and after years of pivot tables I realized there must be a better way, and taught myself MySQL. I built a really nice functional database and it works great. And the RDBMS system totally blows my mind, and I'm starting to migrate all my business info into a database system.
I can definitely crack open MySQL Workbench to add new client info through SQL command line, but is that how it's commonly used? A lot of info has to be populated across multiple tables, and it seems like I need a CRUD app. What's the next step here? Is PHP/HTML a logical direction? I don't need any of my team to have access to the database, but if that's the most common extension than I'll do it.
Thanks in advance!
So, after googling for the past couple of hours, I find myself at a loss to connect my login page to my mysql database.
I want, if possible to open my login form through a browser, input login data, compare that login data with the contents of my database. If there exists a user with that email and password, take me to a page that says "Login Succesfull".
Another question, to be able to use php code, do I need to install xampp? I already created a server and a database iny mysql Workbench. (Also the database is connected to the server).
Hello,
I am working on a MySQL database for school, and my assignment was to create a database using data provided in a textbook. I was to do this in the MySQL Command Line environment. I finished the assignment, however the professor wanted me to run a \T command to save the output of my work into a .txt file. Since I closed my session, I cannot get my queries back. As a result, I have to drop my tables and reenter my data, and then save the output of that.
I attempted to reverse engineer my project in Workbench in order to get the commands back so it would take less time to reenter the data. However, I am running into a roadblock. I can reverse engineer my project into a model, and then forward engineer it into a script, but the script only shows my CREATE commands. I even went back and checked the box that said "Generate INSERT statements" or something to that extent, but it still will only generate the CREATE statements for my tables.
I am running these on Windows 10 if that makes a difference.
Any help would be greatly appreciated!
EDIT: I have solved my problem thanks to some help from /u/jynus. To export the CREATE and INSERT commands open Workbench, and connect to your database. Go up to the top and click Server > Data Export. Click which tables you want included in the export, save the folder to whichever path you'd like, then be sure to go towards the bottom and click "Include Create Schema", and your done!
I am currently 40 lbs over carry weight in whitesprings resort and cannot find a place to scrap this junk (to reduce my carry weight and allow me to ft). I am shocked there is seemingly none inside the resort or anywhere I can find nearby. Be great if there was a way to look up where the closest one would be wherever you are.
If it's possible, how do I do it? Do I need a plugin? I can't figure it out.
I don't know if this matters, but it would have to work in MySQL Workbench. Im sure there are better places but thats just what Im sticking with while I learn.
Thanks!
I find the Data Modeler module of MySQL Workbench to be a great tool. It allows me to design a multi-database system quickly, and its ability to forward engineer that into an SQL script is an invaluable feature for rapidly turning the design into working code.
I do wish it had some form of version control, though. Like with software, I do rapid development with my database structure, and frequently add/remove/modify tables/columns/databases as needed. When this happens, I manually create change scripts both to migrate and roll back a working database between the old and new versions.
Is there any tool similar to MySQL's Data Modeler with the addition of automatically generating migration scripts between versions? Also, for those with similar workflows, is there anything I can do better? All constructive feedback is appreciated.
Hello, dear /r/mySQL!
I'm working at a startup in a jack-of-all-trades capacity.
Currently, I need some infos from our MySQL database. I can access and query it through PhpMyAdmin, but I would like to use MySQL Workbench as I feel that it's more reliable and faster to write code, query it, fix it, and so on.
Hence, my questions to our fellow SQL masters here are:
-
Is it possible to use MySQL Workbench or any IDE to query this database?
-
Which kind of information I need to do so? (login accounts, passwords, server addresses... you tell me)
-
Which kind of software I need to use? (BTW, I have a W10/Fedora laptop)
Thank you for your time (:
