I have tried MySQL Workbench to create database diagrams. There is a function that lets you export your database schema as a SQL file. But this file is rejected by MySQL Administrator and will not be processed, with a message that the SQL file is generated by mysqldump program. Is there another way to process this file so that I don't ha...
On a very important Windows server we use a scheduled task set up by the mysqladmin utility to back up our critical data. I'd like to use the simpler mysqldump command, but I want to ensure that the output is the same. Presumably mysqladmin and mysqldump both share a common core dumping component, so for any given setting in mysqladmin ...
I have a mysql server that gets a lot of users logging in at once. I know in windows you can change the settings so the amount of people logging into the server will be okay on your traffic, but how can you do this on the mac? Thanks ...
Hi - I am running several schemas on a single mysql server. One of the schemas has an underscore in its name ("some_name"), and the rest don't. I noticed that in the Admin GUI I am seeing 2 schemas that represent the same one, with one having an escape character before the underscore - so in the schema list I see: schema1 schema2 some_...
I've managed to corrupt (or something) the 'sessions' table in a mysql db i have (which is called "e_learning_resource_prelive"). This wouldn't be a problem normally as i could just go back to a backup dump of the db. However, the corrupted table seems to be stopping me deleting the database: > mysqladmin -u root drop e_learning_resou...
can anyone tell me how to learn Mysql administration....i've already done basic commands line DML,DDl etc... I just want to learn the administration part of Mysql .I've googled a lot for this but only results in lots of links.... thanx in advance ...
I tried to do: mysqladmin -u root password <password> But I got the following error: mysqladmin: connect to server at 'localhost' failed. error: 'Access denied for user 'root'@'localhost' (using password: NO)' What could be causing this? This is a new install of MySQL and I have never configured MySQLadmin, or as far as I know I h...