Import All MySQL Sql Dumps in a Folder
This command will import all the MySQL sql dumps in the current folder. You can use this to restore your backuped databases.
for i in *; do mysql -uroot `basename $i .sql` < $i; done
This command will import all the MySQL sql dumps in the current folder. You can use this to restore your backuped databases.
for i in *; do mysql -uroot `basename $i .sql` < $i; done
This command fetches a web page, converts it to text and shows it.
lynx -dump http://www.example.com/
Restoring a backup created by the dump command.
restore -if home_backup.bak
Make a incremental backup of directory ‘/home/binnyva’
dump -1aj -f home.bak /home/binnyva/
Make a full backup of directory ‘/home’
dump -0aj -f home.bak /home
This command can be used to backup MySQL database.
mysqldump -u <User> -p <Database name> [<Table name>] > backup.sql
This command will create a file ‘backup.sql’ that will have all the data of the Database. The <Table name> is optional.
The database can be restored from such a dump using the command
mysql -u <User> <Database name> < backup.sql
I backup all the task in Nexty using this command.
mysqldump -u root Apps_Nexty > nexty.sql
This will create a file called ‘nexty.sql’ – which can be restored using the command…
mysql -u root Apps_nexty < nexty.sql