All Questions
64 questions
2
votes
2
answers
2k
views
MySQL export user with semi-colon ";" on the end
I am trying to set up automatic export of user accounts from one server to import into another. I am running the following command;
$ mysql -u root -p -B -s -e "show grants for 'myuser'@'localhost';" ...
- 233
31
votes
2
answers
22k
views
How can I determine the size of a dump file prior to dumping?
How can I determine or estimate the size of the SQL dump file prior to using something like mysqldump?
- 435
2
votes
0
answers
2k
views
Better query to select multiple columns into a single output column? [duplicate]
I have the following query that sort of works, but I find it to be kludgy and inefficient. Is there a better way to write this query?
I know this is a bit of an odd query, else I would probably have ...
- 133
3
votes
1
answer
3k
views
How to restrict MySQL user to not import and export database
I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
- 131
2
votes
1
answer
1k
views
Database schema size result differs from file size when exported
I used this query to find out my database size
SELECT table_schema "Data Base Name",
sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY ...
- 21
3
votes
1
answer
2k
views
It is possible to export a MySQL database without BLOB fields?
If I have a MySQL database with some tables where one have a BLOB column, It is possible to export the whole database excluding the BLOB fields? If not, could you suggest a solution to work-around it?
- 185
1
vote
2
answers
1k
views
Lost connection to MySQL server during query
Here is a part of my query:
SELECT *
INTO OUTFILE 'Target_File_Name' fields TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ''
FROM (
SELECT 'Start time',
...
- 191
7
votes
4
answers
8k
views
Exporting/Importing a large MySQL database without mysqldump
I'm attempting to export about 150GB of data from a database with hundreds of tables, and have found mysqldump to be very buggy.
After running a simple --all-databases dump succeeds, but the import ...
- 71
4
votes
2
answers
2k
views
Import and Export database in Mongo just like MySQL
I am newbie to the Mongo.Before this I have worked only with MySQL.In MySQL we can import and export database easily.I want to know is there any option available in Mongo to import and export database ...
- 681
15
votes
3
answers
33k
views
How to export mysql database based on a where condition
I need to export the data and structure of a table but the data must have a specific condition (WHERE status=0 and id>20).
How to export mysql database based on a where condition from phpMyAdmin or ...
- 1,104
0
votes
1
answer
218
views
Sensible data management tool for importing and exporting of large data files
I am looking for some sensible suggestions on data management tools for large data files.
I have been experimenting aith excel and access only to find that access has limitations on import files size ...
- 101
3
votes
3
answers
1k
views
What's the easiest way to re-format CSV exports from MySQL into Excel/ flat-file fields?
I've just had some database backup problems on a website I run containing some important lead data. Unfortunately, I've now lost one of the key MySQL tables, which means my data has lost its ...
- 145
22
votes
1
answer
22k
views
Does mysqldump export indices, by default?
I played around a little with mysqldump and I was wondering, if it does export indices (FULLTEXT, INDEX,...) by default. I read up on it and I found this option:
--disable-keys, -K
which suggests, ...
- 377
45
votes
9
answers
261k
views
MySQL DB import/export command line in Windows
How do I import and export a local instance of a MySQL database via command-line interface?
My operating system is Windows and WampServer server is installed.
- 559