I've got a 3.5gb database dump. Is there a way to restore just a single table from that file to a differently named table in the same database without editing the file, using mysqladmin, or some other commonly available command line application that runs on FreeBSD 6? ...
It's a long sentence, anyone knows? ...
I've worked on a project using a proprietary non-SQL DB where queries could be interrupted and in the codebase there were quite some spots where that functionnality was used and made perfect sense (for example to stop a long running query that gets cancelled by the user, or when a more recent query takes place and renders the previous qu...
I have 2 table and I wanna a query with 3 column result in on of them 2 column with view count and title name and in the other 1 column with type_ and i wanna to grouping type_ with max(view count) and show the them title but i didn't have any idea about grouping expression. i think we can solve in by using sub query but i don't kno...
I have several tables with some pretty standard data in each. Can somebody help me optimize them by telling me the best column types for this data. Whats beside them is what I have currently. Number (max length 7) --> MEDIUMINT(8) Unsigned Text (max length 30) --> VARCHAR(30) Text (max length 200) --> VARCHAR(200) Email Address (max len...
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...
So,we have a script which monitors mysql every 70 seconds. First it checks for the pidof mysql and then if it finds the pid, it runs mysqladmin -s status -p<password> Now recently we observed mysqld going to 100% cpu load. What I want to know is, will mysqladmin itself FAIL or stall or whatever when the cpu load is 100%? ...