1
vote
2answers
539 views

Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?

We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
3
votes
3answers
959 views

Export massive MySQL database, from a shared level hosting account

I need to export a huge database, with thousands of tables and millions of rows. I'm on shared hosting so I can't use command line exports, and I really have no easy way to get to this data other than ...
6
votes
3answers
11k views

How Export Result of MySQL Query on PHPMyAdmin 3.4.3?

1) I've got a 30K row table. 2) When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K. 3) I want to export the grouped 7K rows as a new table, or save them ...
4
votes
2answers
2k views

MySQL export tables with prefix from Unix command line

I want to export certain tables from one database and import them to another. The tables in question are used for my MediaWiki installation and are prefixed with "wiki_". I do not have access to ...
2
votes
1answer
66 views

How to Properly Migrate SQL

If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server. I notice that in this process, ...
2
votes
3answers
2k views

How do I back-up a MySQL database from the command-line in CentOS?

I need to make a back-up of a database on CentOS 5.5, running MySQL server from the command line. Basically I need to export everything in it.
0
votes
2answers
205 views

Cannot import my MySQL database to new server

In phpmyadmin, when I try to import the database, I get this error: http://i.stack.imgur.com/iDBfE.png I do not understand why it wont let me import it. Im running RedHat x86_64 es5. Both my old and ...
0
votes
2answers
136 views

How do I export table “practices” from db1 into db2? How do I do all tables from db1 into db2? Mysql

How do I export table "practices" from db1 into db2? How do I do all tables from db1 into db2? With Mysql, fill in the blank. What do I type at the prompt: Mysql>
3
votes
4answers
2k views

mysqldump --where with = operator doesn't get all rows

I have a situation with a particular table that now thinks it contains 4 Petabytes of data. I know that sounds cool, but I assure you, it is only on a 60GB partition. This table has 9 fields in it. ...
1
vote
2answers
693 views

export from Oracle into SQL Server/mySQL

I have an Oracle database which we will be removing shortly. But I would like to store some of the data somewhere else so if can be accessed if required. Is there a standard/recommended method of ...