Tag: Backup
-
How to backup the SQL Jobs Script using Power Shell
-
How to Backup MYSQL Databases
REM Export all databases names to file mysql -h your-server-ip -u user-name -ppassword information_schema –skip-column-names –execute=”SHOW DATABASES;” > databases.tmp echo “Start!” REM Look over database names REM Outter loop to get table names for /F %%A in (databases.tmp) do ( echo “Exporting table Names for %%A” mysql -h your-server-ip -u user-name -ppassword %%A –skip-column-names –execute=”SHOW…
-
How to Backup Microsoft SQL Server (MSSQL) Databases
–1. Variable declaration DECLARE @path VARCHAR(500) DECLARE @name VARCHAR(500) DECLARE @filename VARCHAR(256) — 2. Setting the backup path SET @path = ‘X:\MSSQLDB\Backup\’ DECLARE db_cursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN (‘master’,’model’,’msdb’,’tempdb’) — ignore system databases –3. Initializing cursor operations OPEN db_cursor FETCH NEXT FROM db_cursor INTO @name WHILE @@FETCH_STATUS = 0…
-
How to recover an archived email from your gmail account
Most of the people in the world are using GMAIL for their email, its a free and support unlimited storage (15 GB). Some times while viewing the email on desktop / handheld devices, archived option is clicked accidentally. If you want to recover that email from archived folder, just use these steps: Open your gmail…
-
How to export schema of MYSQL Database?
If you need schema of your MYSQL database for backup or any copy database to another server, then you must need schema with or without data. GUI tools like SQLYog, WebYog or PHPmyAdmin will best example for that. But if you need any command or utility then MYSQLDUMP has most important role. For using mysqldump…