Tag Info

New answers tagged

2

This is likely to be a bug in the version of MySQL 5.1 that you are running, causing the server to provide incorrect metadata to mysqldump when it uses DESCRIBE to learn about the composition of views. http://bugs.mysql.com/bug.php?id=65379 Background: any time you create a view that references a table, that table must already exist before you can create a ...


1

The physical standby database must be physically the same as the primary database and this means the versions must be identical. A logical standby database can be any version, depending on how it is implemented. With 3rd party tools you can go from v10 to v12 and back. The restrictions here are on the data types that are to be replicated. If this is for an ...


1

MyISAM didn't change between 5.5 and 5.6. It's not being developed, and it's virtually stagnant. Use FLUSH TABLES WITH READ LOCK and then it's safe to copy the MyISAM tables. This is mentioned in https://dev.mysql.com/doc/refman/5.6/en/backup-methods.html Other solutions: mysqldump --tab outputs tab-delimited data files instead of SQL, so it's much ...


3

exp and expdp are OS command-line programs. That's why SQL*Plus doesn't recognise them. You need to fire up a console (shell) window. Note that you can run these wherever makes more sense, your local PC or on the database server itself, provided the Oracle client software is installed. There is an in-database API for Datapump. It's the PL/SQL ...


7

This answer applies to modifying the PostgreSQL source code by applying a "diff" or "patch". It's not about installing minor version updates; to do that, just download and run the installer. To alter the PostgreSQL server its self or its procedural language runtimes, you will generally need to recompile PostgreSQL from scratch. On Windows that's a bit of ...


0

It really depends how big, complicated and active your database is. Bear in mind that while you are making schema changes, many of the tables will be read-only or completely inaccessible until the changes are completed. Also bear in mind that the reverse is true - your schema changes will need to acquire exclusive locks on entire tables and possibly all ...


0

What I do is to build and test a script with the changes in a development server. It must upgrade the db in a totally automated and reproducible way. That includes running it with the same user with the same permissions with which it will be run in the production server. That said this question is too broad and should be asked in ...



Top 50 recent answers are included