Tagged Questions
0
votes
2answers
63 views
Need Permissions Granted: INTO OUTFILE for Mac OS X [closed]
Sorry for potential duplicate questioning, because I've seen this asked many times (notably from Mac users) -- but none of the answers seemed to help me.
I'm using Mac OS X with Sequel Pro (or I can ...
1
vote
2answers
97 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';" ...
2
votes
1answer
34 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?
2
votes
1answer
363 views
Better query to select multiple columns into a single output column?
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 ...
1
vote
1answer
166 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?
2
votes
1answer
187 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 ...
0
votes
1answer
222 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?
...
4
votes
4answers
562 views
Exporting\Importing a large MySQL data 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 ...
3
votes
2answers
375 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 ...
2
votes
1answer
457 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 ...
0
votes
1answer
122 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 ...
2
votes
3answers
301 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 ...
7
votes
1answer
3k 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, ...
