Johann Savalle

@yasha.solutions

Product designer and full stack developper living in france
< Back to all articles

MySQL Mockdata

January 07, 2019

Step 1: Generate the mock data

Go to Mockaroo a random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel

Download as SQL / include Create if you want

Step 2: Prepare a database accessible remotely

Create a database and user somewhere online.
For instance with a service like http://remotemysql.com

Step 3: Import the data in the database

mysql -u user -pPasswords -P 3306 -h remotemysql.com < data.sql

Step 4: Check

You can use phpMyAdmin on remoteSQL website to check your data was processed in properly

< Back to all articles