Please call me up and lets use Zoom or any other screen sharing application so you can see what happens. Ive been trying to create a new connection on MySQL Workbench. My IT startup needs to get the data onto the AWS server or we risk going belly up.Ĭan anyone please help me out and fix this? I need to create a new RDS MySQL database by August as my previous EC2 RDS instance is. I've tried to get mysqldump to work using MacOs terminal command line instructions, but it is a complete nightmare - I'm totally out of my depth. I'm completely self taught with MySql, and I find it incredibly dense and hard to understand. The unix executable file mysqldump is present and correct and dated Septemat 5:44pmĪbout 60Gb of precious data is currently trapped on my 2017 MacBook, and I need to make a backup so I can get it onto and AWS server but I am totally stumped. I have scoured all the threads for almost a week, tried all the proposed solutions that have been proposed, and it just will not work. The Workbench export function works just fine on two other MySql installations on a 2018 MacMini and a 2013 MacBook Pro, but on the 2017 MacBook it is a dud. MySQL Workbench is an official graphical tool to manage the MySQL database. Today, our AWS Support Team is going to demonstrate how to connect to AWS RDS database with MySQL Workbench. Workbench can be installed on your local laptop/desktop. Moreover, it offers a query tool that performs SQL queries to the database server. From the AWS CloudFormation console, on the BastionStack Outputs tab, note the value for EIP1, as shown in Figure 2. On the other hand, MySQL Workbench is a desktop application that enhances visibility within relational database servers via an easy-to-use graphical UI. I have tried to get MySql Workbench to dump the database to an external SSD so it can be transported to AWS, but I keep getting the message "Could not get mysqldump version" even when in Workbench preferences I provide the Path to mysqldump Tool.įor some inexplicable reason, every version of Workbench that I install simply fails to connect to the mysqldump executable that is stored in /usr/local/mysql-8.0.22-macos10.15-x86_64/bin. Download the latest version of MySQL Workbench, and install it on the workstation from which you will be connecting to the Aurora MySQL DB cluster. I have a massive (200 million+ records) database stored in MySql 8.0.022 on a 2017 MacBookPro which I have just spent over a week processing and analyzing for eventual upload to an AWS Production server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |