- Forums
- Linux Programming
- How To Import MySQL Database File in Linux Shell Command example.sql
this post will show you what command you can use to import an .sql file extention through thelinux command line shell [8893], Last Updated: Sat May 18, 2024
wallpaperama
Wed Dec 31, 1969
0 Comments
103 Visits
lets say i have a file called mybackup.sql
how can i import it back to my database. well i will show yo.
so lets say i want to import mybackup.sql into my mywallpapers table in my wallpapers database. this is how i would do it
this is the format:
mysql -u [USERNAME] -p[PASSWORD] [DATABASENAME] < FILENAME
so this is how my command will execute:
mysql -u [USERNAME] -p[PASSWORD] wallpapers < mybackup.sql