New answers tagged restore
-1
You ask if you can "restore mysql database with different name from mysqldump file".
The answer is that you should NOT restore to another database if you have defined triggers with explicit chema name, due to a mysqldump bug, at least not without transforming the dump (see below).
(That is the short answer. You may not like it, you can downvote, ...
0
You can do this by guaranteeing that the account vendor is using does not have a corresponding user in any databases other than these two.
CREATE ANY DATABASE will give the vendor privilege to do the required restore.
The following code will demonstrate that the user vendor cannot drop databases.
CREATE LOGIN vendor
WITH PASSWORD = N'Change_Password',
...
0
SQL Server is working fine on Linux ;-)
So, this is my own solution for filelistonly (working too for any of the auxiliary statements):
sqlcmd -U *** -P *** -Q "restore filelistonly FROM DISK = '/tmp/backup.bak';" -o /tmp/metadata.out
tr -s ' ' < /tmp/metadata.out | cut -d' ' -f1,2,3,4,5 | tail -n +3 | head -n -2
2
As @AndrewSayer said, it has nothing to do with your dmp file. In order to connect to a database, the client (in your case, 'imp' utility) has to be able to locate the database. This means knowing the server the database is on, the port the database listener is uing, and the service name by which the listener knows the database. This information is ...
2
Using rsync is fine as long as the database were shut down at the time, which apparently was not the case here. But what were you doing while the rsync was running? Did you start the rsync when the cluster was empty, and then run it very slowly (low --bwlimit) while you also restored large dump files into the system? The amount of corruption you are seeing ...
-2
controlfile=/ArchiveDBBackup/DAILY_RMAN/${DD}/CDB1_CONTROLFILE
intead
controlfile=/ArchiveDBBackup/DAILY_RMAN/${DD}/CDB1_CONTROLFILE
Try as above.
0
Fundamentally, a DR scenario might fall into two basic categories:
You want a "hot standby" solution, wherin in the case of your primary database failing you can switch over to the standby server. PostgreSQL achieves this through it's hot standby functionality - which also provides you with a secondary server that you can shuttle read only ...
1
screen
screen is like 'open me a virtual terminal that I can detach from, then re-attach to later'. You use it for long-running processes when you want to disconnect from the box.
You start a screen by entering the command screen (and press enter to clear the first message). Now you are in a new session. Run what you like. You can & it if you like, but I ...
2
External Drives to the Rescue
I had a similar situation (needed hard drive upgrade on a server with most of the space taken by an active database) years ago with a server in a data center (long story...) and the solution was to buy an external hard drive (via the data center, so it cost a bit extra) and use that to store the backups, do the upgrade and then ...
3
At least 2 approaches:
Put the backup on a shared folder, make the SQL server restore from the shared folder. The MS SQL server accepts shared folder syntax (\server\share\file.bak) pretty well. It will not copy the database locally, it will read it from the shared drive. Depending on your shared folder permissions, this may require logging in as the SQL ...
1
Reference:
log_shipping_monitor_secondary (Transact-SQL)
sp_help_log_shipping_monitor (Transact-SQL)
Monitor Transaction Log shipping using T-SQL and SSMS by Jignesh Raiyani
View the Log Shipping Report (SQL Server Management Studio)
Using TSQL get details of last restored transaction log Backup (Subscriber Side):
SELECT b.type, b.first_lsn, b.last_lsn, b....
7
Once you have restored the database on another system, you can detach the database, move/copy all DB files (data and log) to your target system and attach the database there. The method is relatively simple in most circumstances, you can follow this Microsoft doc for commands and this concept doc for more detail.
Databases will usually grow over time, you ...
Top 50 recent answers are included
