Level 104
Do you use a GUI; TablePlus, Sequel Ace, etc?
Or, are you comfortable on commandline?
Nov 23, 2021
7
Level 3
How to Add Existing Database to Forge?
Hi Guys,
I've just started using Laravel Forge (Fantastic service). I've setup my server and have my site up and running. However, I cant seem to figure out how to import my existing database data to my new database. Cant someone point me in the right direction?
Level 3
@tykus Using table plus at the moment, not very comfortable on command line regarding database interactions.
Level 104
@AtomCoder you can connect to the remote database over SSH using your key (assuming you have added your public key to the server in Forge).
In TablePlus
- create a new connection
- enter the
127.0.0.1for the Host - enter the
3306for the Host - enter the remote database username in User
- enter the remote database password in Password
- click on Over SSH
- enter the remote server IP address in Server
- enter
22in the port (assuming standard SSH port) - enter
forgefor User - click Use SSH Key and select you private key (matching the public one in Forge)
- test the connection, and save if successful
Working?
Level 104
Next depending on what you need, you can either Backup the original (local?) database or you can create an Export of the selected tables' content as SQL. Then Import the resulting SQL file into the remote database.
Level 3
@tykus That did the trick. I had issues importing the data, duplicate keys in some tables etc...
Level 102
@AtomCoder remember to mark a best answer if it was solved
1 like
Level 3
Just did there now. Thanks guys 👍
Please or to participate in this conversation.