-1

Am making a website, hosted on netlify, and i've made the database on MySQL workbench, how do I import it into my PlanetScale? to be live.

Shadow
  • 33,525
  • 10
  • 51
  • 64
Omar Alkhateeb
  • 21
  • 3

1 Answers1

0

They seem to have some instruction here on how to import data from a database that you have.

https://planetscale.com/docs/imports/database-imports

You might use some free tier hosting provided by a cloud provider to publicly host your db and then use this import client they have.

Alternatively, you might simply run mysql-dump on your existing database to create a dump.sql file with your existing db, and then run that dump file with the mysql client of your choice pointed at your planetscale db to create the database.

Alden W.
  • 1,362
  • 12
  • 19
  • I couldn't understand!, i ran mysqldump using --all-databases, where is the dump.sql file? what is the mysql client that i should use? at least suggest one, what is a cloud provider? and why can't i directly import this db to planetscale? it have this command mysql --ssl-mode=VERIFY_IDENTITY --ssl-ca=/etc/ssl/certs/ca-certificates.crt This command is in the planetscale docs, but my verification method is password, not SSL cert. – Omar Alkhateeb Aug 30 '23 at 02:53