You can try to use sed in order to extract only the table you want. Let say the name of your table is mytable and the file mysql.dump is the file containing your huge dump: $ sed -n -e ‘/CREATE TABLE.*`mytable`/,/Table structure for table/p’ mysql.dump > mytable.dump This will copy in the file mytable.dump what … Read more
if I want to revert the container I can try to commit an image, and then later delete the container, and create a new container from the committed image. But if I do that the volume gets deleted and all my data is gone As the docker user guide explains, data volumes are meant to … Read more
Use –table to tell pg_dump what table it has to backup: pg_dump –host localhost –port 5432 –username postgres –format plain –verbose –file “<abstract_file_path>” –table public.tablename dbname
You can create a new db then use the “Restore Wizard” enabling the Overwrite option or: View the contents of the backup file: RESTORE FILELISTONLY FROM DISK=’c:\your.bak’ note the logical names of the .mdf & .ldf from the results, then: RESTORE DATABASE MyTempCopy FROM DISK=’c:\your.bak’ WITH MOVE ‘LogicalNameForTheMDF’ TO ‘c:\MyTempCopy.mdf’, MOVE ‘LogicalNameForTheLDF’ TO ‘c:\MyTempCopy_log.ldf’ This … Read more
In Microsoft SQL Server Management Studio you can right-click on the database you wish to backup and click Tasks -> Generate Scripts. This pops open a wizard where you can set the following in order to perform a decent backup of your database, even on a remote server: Select the database you wish to backup … Read more
Backup your databases docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y”_”%H_%M_%S`.sql Restore your databases cat your_dump.sql | docker exec -i your-db-container psql -U postgres
tar -cjf site1.tar.bz2 -C /var/www/site1 . In the above example, tar will change to directory /var/www/site1 before doing its thing because the option -C /var/www/site1 was given. From man tar: OTHER OPTIONS -C, –directory DIR change to directory DIR
There are two tools to look at, depending on how you created the dump file. Your first source of reference should be the man page pg_dump as that is what creates the dump itself. It says: Dumps can be output in script or archive file formats. Script dumps are plain-text files containing the SQL commands … Read more
Dump and restore a single table from .sql Dump mysqldump db_name table_name > table_name.sql Dumping from a remote database mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql For further reference: http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql or in one line mysql -u username -p db_name < /path/to/table_name.sql Dump and … Read more
I had this situation restoring a database to an SQL Server 2005 Standard Edition instance using Symantec Backup Exec 11d. After the restore job completed the database remained in a “Restoring” state. I had no disk space issues– the database simply didn’t come out of the “Restoring” state. I ran the following query against the … Read more