I want to perform the dump of a remote (not on local machine) mariadb database locally using a container created with the official mariadb image. The final goal is to import the remote database into ...

I need some details on importing and exporting a MySQL 8 database. If the entire database is backed up in one dump, is it possible to restore a single table, or should the individual tables be ...

I have a website with very specific JS code associated with a large, unchanging, MySQL database. I want to be able to distribute the website plus database as a single package for others to be able to ...

I have a SQL dump file: C:\Users\Rayyan\Desktop\dump_2.sql. I have been trying to import this for so long. I am using pgadmin 4, and since I could find nothing in that gui to help, I tried using psql ...

I have a script where pg_dump is failing with a message like this: pg_dump -h db1 --format plain --encoding UTF8 --schema=public --schema-only --no-owner me pg_dump: [archiver (db)] query failed: ...

I know that to take database dump I can ignore some tables. but I want to take the dump of all table with some percentage of data like 20% 40% because the whole dump is too big. here is my normal dump ...

I am using IntelliJ and its database plugin to export data from a table on one database to a table on another database. The tool works brilliantly, but I need to perform this task repeatedly. Is ...

We have Odoo 8 running on Digital Ocean and would like to move database to local intranet. For that I setup Odoo 8 on local machine. I wanted to export the database, but I am failing to export from ...

I am having trouble understanding the values that I have saved in my Round Robin Database. I do a dump with rrdtool dump mydatabase and I get a dump of the data. I found the most recent update, and ...

I am trying to pull my pg database on heroku into my local development database. I am running heroku pg:pull HEROKU_POSTGRESQL_URL LOCAL_POSTGRE --app MY_APP Unfortunately I get : pg_dump: server ...

i am trying to take dump of database using CLI mariaDb i am executing following query. mysql -u root -p --database = byx_prod_db < dumpfile.sql; i am getting this error ERROR 1064 (42000): You ...

Using Oracle SQL Developer, I want to export databases to SQL scripts using the "Tools" > "Database Export" menu entry. I selected all the DDL entry to export. The problem now is the SQL file ...

I am trying to dump the database in my local system by using the command : pg_restore --host=localhost --port=5432 --dbname=dev_db --no-owner --no-privileges db_dump_new.backup but I am getting the ...

I have been assigned to move 10g database to Oracle 12c on a Solaris. Size of data is around 68 GB. So far I have managed to install the Oracle 12c on Solaris and also created the default DB it asks ...

I can generate a sqlite3 dump file with sqlite3 app.db .dump > app_dump.sql however, if there is a row in that database which has no entry it is just left out in the dump file. This is a problem ...