All Questions

Tagged with
Filter by
Sorted by
Tagged with
-1
votes
1answer
591 views

Restore database - Operating system error 5(Access is denied.) on Linux

I try to restore SQL Server 2017 Express database using sqlcmd tool on Ubuntu 16 Server. My SQL command is: RESTORE DATABASE [xxxxx] FROM DISK = N'/home/xxxxxx/DBBackups/xxxx.bak' WITH NORECOVERY, ...
0
votes
1answer
32 views

Would installing 32 bit packages on the existing 64-bit VM be an option to run Oracle 9.2?

I inherited an old old 9i DB that now needs recovery. It is unstable (disk corruption and performance problems). I have a backup. In the interest of time - I have 64-bit VMs all over the place, but ...
1
vote
1answer
153 views

SQLServer Linux: Error restoring backup of DB from Windows w/ full-text data file

I'm trying to move a Windows SQL Server database from Windows 10 to Linux. For this, I'm following the instructions in https://docs.microsoft.com/es-es/sql/linux/sql-server-linux-migrate-restore-...
0
votes
1answer
61 views

SQLServer Linux: Restore full database / Catalog

UPDATE: I continue with the same error, but, with the comments, I have done some progress: - Initially, the full text search feature was not in my installation. I installed with https://docs.microsoft....
2
votes
1answer
72 views

How to ensure security with SQL Server Restore

I'm building a shared hosting SQL Server tool for linux, where users only receive access to their own database, with a SQL Login and SQL Database User that has db_datareader, db_datawriter and ...
0
votes
1answer
318 views

PostgreSQL + why archive_command line is marked after barman restore

I use the barman tool as backup & restore for PostgreSQL after I restored successfully the data folder under /var/lib/pgsql by the barman we have seen that the line with archive_command was ...
2
votes
2answers
678 views

Why is pg_restore unable to create database with --create option before restoring from dump?

Why pg_restore is unable to create database with --create option before restoring from dump? pg_restore --username=myuser --create --dbname=mydb --verbose mybackup Error, pg_restore: [archiver (db)...
0
votes
1answer
443 views

barman + postgresql not start after barman retore

I use the barman for backup and restore after some restore , we start the postgresql as the following systemctl start postgresql.service but postgresql not startup from the log: /var/lib/pgsql/...
-1
votes
1answer
226 views

barman + barman can show the details from backup directory

we have linux machine as backup server with barman tool when I want to see the details backup with the command barman show-backup then I get the following exceptions # barman show-backup main-db-...
1
vote
1answer
187 views

MonetDB auto-backup mechanic problem

I'm trying to set up mechanism that will automatically create database backup. The idea is to create a script that will be executed by crontab. Seems easy but I'm struggling with the following ...
3
votes
1answer
4k views

How to restore database from /var/lib/mysql

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
15
votes
2answers
39k views

Table is marked as crashed and should be repaired

I have MySQL and Nagios installed Linux PC (Centos5.5) I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table) The data fetching working properly (confirmed ...
3
votes
2answers
4k views

Can I find out what version of MySQL from the data files?

I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...