Options Area Of MySQL Administrator
trying to get Apache/PHP/MySQL setup on a Mac OS X Server version 10.4.9. Those come installed by default, and I also added MySQL Administrator and phpMyAdmin. Everything is working, except for the Options area of MySQL Administrator.
Instead of getting the various options, I get a note at the bottom that says: "Could not read configuration file."
I'd imagine that some config file somewhere needs editing, but I'm not sure exactly what needs to be done.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MySQL Backup Options
I was using mysqldump to perform MySQL backups just fine. However, we recently had to restore the database and it took about 10 hours for 100GB to restore. Now they (managers) want me to find a different method, one that will restore faster. So I tried using MySQL administrator's backup utility but it takes twice as long and is twice as big! I doubt this will speed up the restore. So, my first question is why is it so big and why does it take so long? Is it giving me something that I won't get using mysqldump? And my second question is how can I optimize one of these methods so a restore doesn't take half a day?
Importing To Mysql From MS Access-csv Options
I am having problem importing an Access 2000 csv into mysql using phpMyAdmin. I have set CSV options: fields terminated by {,} fields enclosed by {,} fields escaped by {don't know what to put here} Lines terminated by {don't know what to put here} Column names {don't know what to put here} the first row of the input file has the field names will someone tell me the correct parameters for this kind of input file?
Mysql Command Line Options
I am executing the following from the command line. mysql -uroot -t rep_queries_${yearmth} -A <<QUERY_INPUT SELECT count( distinct source_ip) from day_${yearmthday} where query_ip = $numip QUERY_INPUT It returns the heading along with the result (see below). Can I suppress things so that only the result is returned? I need to store the result in a unix variable. +----------------------------+ | count( distinct source_ip) | +----------------------------+ | 41 | +----------------------------+
Check Compiled In Options To Mysql Binary
How do I find out what options were compiled into the binary versions of mysql? Also, is there a way to see what options were compiled when a binary was manually created with configure/make/make install. Is there a query you can do on the daemon?
Backup Options Non Functional - MySQL Admin
I have inherited a small MySQL database, version 5.x. I have installed MySQL Administrator. I would like to try the backup utilities offered in this application, but they are all greyed-out and non-functional. It doesn't matter whether the application is run on the local host or on a client workstation -- the backup features are non-functional.
Dropdown List - Insert Into Mysql. Options
This is something probably simple but confuses me. I simply want to add a dropdown list where, when an option is selected, its value will be inserted into a dbase table. More specifically, assume there is a page where the user sees his order. He will be able to select the order status (pending or delivered). So, for example, if his ordered is delivered, by selecting "delivered" option, "delivered" will be inserted into the 'Status' Table.
Area Of Polygon
I have a table which contains the dimensions for a restaurant, and the dimensions of various pieces of unusable space. I've done this as so: CREATE TABLE restaurant ( id TINYINT NOT NULL AUTO_INCREMENT, dimensions GEOMETRY NOT NULL, unusable_space GEOMETRY NULL, PRIMARY KEY(id) ); SET @dimensions = 'POLYGON((0 0, 700 0, 700 1050, 0 1050, 0 0))' SET @unusable = 'POLYGON( (0 211, 100 211, 100 630, 0 630, 0 211), (411 0, 510 0, 510 100, 411 100, 411 0), (190 840, 700 840, 700 1050, 190 1050, 190 840) )' INSERT INTO restaurant VALUES(1, GeomFromText(@dimensions), GeomFromText(@unusable)); The problem is when I go to work out the total area of unusable space, rather than returning the correct 158900, it returns 75100. I'm pretty sure this is something to do with the example at http://dev.mysql.com/doc/refman/5.0/...functions.html which inserts one polygon inside another; whereas mine are in altogether different places on the "map".
Data Area
Would someone help me how I could access Data Area (like Local Data Area) using SQL in AS400.
Client Area And Login
I would like to store pictures in mysql and have differnt customer accessing them through password. Is there some ready made solutions or tools that make the code that I can buy, without doing to much work myself.
Setting Up Development Area
Having recently acquired extra MySQL upon my hosting renewal I want to use one of them as a development area for PHP aspects. Now, the one I'm using at the present is for a forum and the way I see the results are via looking at the url page of the forum. How would I go about viewing said results "in-house", so to speak, in the MySQL for the development area? This is probably very simple for many of you but I am new to MySQL and the incorporation of it for the forum was done automatically by the hosting service.
Area Code Lookup
I'm looking for a table with area codes and states for the USA and Canada. To be used for validation in signup forms.
Separate Area Code
Is it possible in MySQL to separate the area code from a field that has the complete phone number? phone 666.666.6666 I'd like to have the fields as area 666 phone 666.6666
Question Regarding MySQL Interface Options And MySQL Vs MS Access
First, there are many applications available for interacting with MySQL. One of the things that frustrated me at first was the CLI. I know that it's the foundation and understanding syntax is critical to making it all work in the end, but when dealing with large datasets, I feel that a GUI makes life easier at times. So, I started out with phpMyAdmin, seems to be 'the' geek-preferred application. I also ran into a few shareware ones here and there as well as Navicat, and I recently learned that there are 2 apps from MySQL.com for administrating the DB and creating queries. In your experience, what seems to be the best MySQL interface application? At the moment I couldn't say *exactly* what I'm looking for, but more-or-less something that will ease the headache of creating queries and managing users, tables, etc. Question #2: I have been hired to be a Web Developer, Network Admin, and Database Administrator all-in-one. We have are a retail company selling peuter goods and have a product line-up of about 100 items. The President wants a robust database to deal with everything. Right now we use MS Excel for our needs. He says it's becoming cumbersome and wants to move on. I suggested MS Access because that's exactly what it's built for, companies that have been running in Excel and want more robust control over what they're doing. But the president keeps hearing this 'MySQL' buzzword and wants a MySQL database. Fine with me, I just know Access better, that's all. I've been cramming PHP & MySQL down as fast as I can and am starting to feel more familiar with both technologies. At the moment, I feel MySQL to be more of a headache (my fault I'm sure, I just don't know it yet) But For Example: To properly normalize a DB, I sometimes have to break a table into 3 tables. The first and second are no problem, but the third 'association' table is annoying (at least doing it CLI or phpMyAdmin). See, Access, you just make 2 tables and graphically set associations very easily. So, from what you know of MySQL, do you think it would be still superior to Access seeing as we want to integrate it into osCommerce eventually and possibly some of their user contributions?
Update Area Code With Paranthesis
I've got a table with phone numbers in the format: 03 1234 5678 and (03) 1234 5678 03 is the area code for all of them. What query could i use to put parenthesis around all the 03 area codes that don't yet have them? The column type is varchar(31).
Local Area Connection (network)
I have a local area connection (network) where the IP addresses are generated automatically. How do I find a server on a different computer in the same network? IP address are always changing so I have no idea how to find a server.
Mysql-administrator
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will not work. When I try to acccess it I get the following message. linux:/home/grabro # mysql-administrator /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib9InterfaceE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib10ObjectBaseE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk9ListStoreE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk5EntryE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib6ObjectE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk6WidgetE' has different size in shared object, consider re-linking *** glibc detected *** /usr/bin/mysql-administrator-bin: free(): invalid pointer: 0x083ca0e0 *** ======= Backtrace: ========= /lib/libc.so.6[0xb716d911] /lib/libc.so.6(__libc_free+0x84)[0xb716ef84] /usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb72e6e51] /usr/lib/libstdc++.so.6(_ZNSs4_Rep10_M_destroyERKSaIcE+0x1d )[0xb72c2fed] /usr/lib/libstdc++.so.6....................................
MySQL Administrator 1.1.9
I am running mySQL database version 3.23.58, but I'm using mySQL Administrator 1.1.9 for scheduled backups. When connecting to the database I get a message saying that this version of database is not supported and I might get unexpected behaviour. Am I OK to use this version of mySQL Administrator to backup my database and what unexpected behaviour can I expect ?
MySQL 5.0 Administrator
I have installed a new MySQL 5.0 administrator and since I am so used to deleting a database directly through data folder in my old mysql 3.23 that I do it now also in MySQL 5.0 rather than deleting it through administrator . Now the problem , if the db is deleted not through administrator , it somehow creates a same name cache of the database and it creates a problem if I try to run a sql script because it gives a error of duplicate name. My question is , Is there a way to delete old cache names of the db's so that new db's can be created or a script can run the db which has been created and deleted before .
MySQL Administrator
I am using the MySQL Administrator version 1.1.3. Why is the "Edit Table Data" grayed out when i right click on a table? Is there a way to ungrayed this? Or is this not part of version 1.1.3 anymore?.
Mysql Administrator 1.0.19
when i click catalogs -> my schemata ; right-click on any InnoDB table i am not able to "edit table data" it is grayed out. What do I have to do to be able to edit table data with mysql admin.
MySQL Administrator
My mysql server's version is 4.1.11_win32 and my MySQL Administrator's version is 1.0.19. When I use MySQL Administrator to modify the user administration, it always shows me "Error while storing the user information!".
MySQL Administrator
I want to view the config file in MySQL Administrator but it says I must be connected to localhost to see it. Can I grant myself permissions to be localhost as well?
MySQL Administrator
I am trying to make one of my fields UNIQUE, however the MySQL table editor has the 'index settings' greyed out so I can not select "UNIQUE". How do I make field unique
MySQL Administrator
I have setup MySQL Admin to run scheduled backups on my databases... do I have to keep the program open in order to run them?
MySQL Administrator 1.0.13
I've just downloaded MySQL Administrator 1.0.13 and wish to connect to a mySQL server v3. When connecting I get a message saying that this server version is not support, which I can ignore. Can someone please advise what problems i might encounter if connecting to an unsupported server version ? My main requirement for the mySQL Administrator program is scheduled backups of the data and table structures.
MySQL Administrator
I have a site hosted with a company. I created a testing sub-domain called testlab.swattle.com In this sub I have created a database called swattle_test and I also added a user called swattle_testuser Now when I go into the MySQL Administrator program on my local machine and try to logon to the server I keep getting an error 1045 I put up the screen shots of at http://testlab.swattle.com I also fired off an email to my hosting company
Mysql Administrator
i installed it for windows i can't seem to get it to connect to the database though, the mysql server is on the same machine as this one. for the hostname i typed in localhost port:3308 (is that the right port?) and my root username and password it gave me an error that it couldnt ping to "localhost" i dont get it
Mysql Administrator
How do I edit table data using Mysql administrator. If I click on edit table data the table opens, but then there is no way to edit the table. At the bottom there is a button to apply changes but this is grayed out.
MySql Administrator
I'm using Innodb on windows server 2003.I noticed today that some of my tables are reported by MySql Administrator to have a far greater number of rows than what is return in a query for all rows. For example, one table shows 51,600 rows in Administrator but when I do a SELECT * on the same table from Query Browser I get a mere 5,293 (this is the correct or "real" number of rows) So, what's up? Why is administrator showing so many more rows? I've also noticed that each time I press the refresh button in Administrator the number of rows changes. one time it might be 50k+ then 30k then 43k, etc, etc. being a newb I'm a bit freaked out by all of this. I've heard that innodb can do some funny things, but this seems REALLY strange. I'm sure it's nothing, I just need to hear it from an experienced user
MySQL Administrator & QueryBuilder
I have installed MySQL 4.0, MySQL Administrator and Querybuilder. In general all functions well. But two things do not function, which I would like to, because I need them: (1) In the menu of Querybuilder --> Tools the link to Administrator is greyed out. How can I make it function? (Administrator to querybuilder is ok) (2) More Important: in Administrator, loggedin as root with all grants, the (context-)menue eintry "edit tables values" is greyed out on any table. - How to make it function? How to edit values in the tables then? (System: WXP-SP2, logged in with admin-rights)
New User [MySQL Administrator]
I'm getting an error when adding a new user: After I've entered MySQL User: XXX-WEB, Password and Confirm Password, I click Apply Changes a message box shows MySQL Administrator Exception: Error while storing the user informaiton. The user might have been deleted. Please refresh the user. I've refreshed, sooo many times... I think I may have messed up the MySQL schema and may have damaged some locks.
MySQL Administrator Disabled
I've just installed MySQL 4.1.5 gamma following the instructions in the documention, and MySQL Administrator 1.0.13 on my home machine. I'm the only user :( ! MySQL seems to be working OK but when I use the Administrator program, which appears to connect to the MySQL service OK, all of the Startup Variable options are disabled on all the panels. I thought I'd be able to tweak these options from here.
Cannot Connect To MySQL Administrator
I am running MySQL 4.1 on Windows XP. I am trying to connect to MySQL administrator. But it is giving the following error when I try to connect: Could not connect to the specified instatnce. MySQL error number 2003 Can’t connect to MySQL server on ‘localhost’(10061) When I run ‘MySQL Command Line Client’ it asks me to enter the password and it takes me to ‘mysql>’. What do I have to do to connect to MySQL Administrator? Or what am I missing?
Having Problems Getting Mysql-administrator To Run
When I run mysql-administrator I get the following error. I installed the generic rpm on a Fedora Core 3 system. I have the latest version of pango. /usr/bin/mysql-administrator-bin: symbol lookup error: /usr/bin/mysql-administrator-bin: undefined symbol: pango_renderer_get_type
MySQL Administrator For Web Administration
Can MySQL Administrator (from this website) be used to administer MySQL database over the web (a far off machine accessible via IP). If not, what is(are) other free software(s) that can easily do it for Windows platform.
MySql Administrator Rules
I find that MySql Administrator is a much more powerful and intuitive way to access databases than phpMyAdmin. I think I will be using this for all my projects now.
Setting Up MySQL Administrator
I just downloaded MySQL Administrator and am trying to install it. I'm trying "localhost" and "root" for Server Host and Username, along with the default setting for Port, 3306. However, I don't have a clue what a "Stored Connection" is. What am I supposed to enter there?
MySQL Administrator Logs
I have been using mysql database on two servers for about three years now. I recently downloaded the new MySQL Administrator and I love it. My only problem is I cannot see logs. I am connected on the local machine and cannot find the option to turn on the logs or anything. I have looked through my.ini and everywhere.
MySQL Administrator Password
I have just installed mySQL 5 Community Edition and also all its tools viz. Administrator, Migration etc.. Presently I have installed it on a machines with no other machines connected to it. I also selected "Developer Machine" option while installing it. When I open mySQL Administrator, it asks for Username and Password. I remember the password, but what is the default Username and Schema Name. If I am running on a standalone machine, what to type in "Server Host" in the administrator window.
Mysql Administrator Issue
I have installed MYSQL 4.1.7, administrator & control center on Windows XP. Mysql server runs fine, I can connect to Mysql administrator or windows command line client. My problem is: 1] While trying to connect in MYSQL Control Center , I get error: === Error 2003: Can't connect to Mysql server on 'THESERVER' (10061) === [host name is fine, port no is also fine, then where I am doing wrong.... ???] 2] I can connect to Mysql Administrator , BUT.. 1) Startup Variables are disabled [I can't alter them...] 2) Clicking SERVICE CONTROL page stops the service and then I could not restart the service again. [seems goophy to me... why its like that ???] 3) While surfing in Mysql Administrator, after a while I get error message: === Mysql Error Number 1226 User 'root' has exceeded the 'max_questions' resource (Current value 100)=== [I set max question value to default (0) or any number, it dosent make difference, and I can't work on administrator unless I re-login] 3] I have created a .sql file containing all tables & relationships I want. How can I load that file in Mysql database. [How can I call/import that .sql file to create tables in Mysql database ??] I am stuck in above little mess, would you please help me out from above problem ?
Installing Mysql-administrator
(This is also posted in the install forum) For some reason I can't get the rpm to install so I tried using the tarball and when I do this, the /opt/mysql-administrator-1.0.19/bin directory does not get created. Command I used to install mysql-administrator: shell> tar --directory=/opt -xzvf mysql-administrator-1.0.19.tar.gz Does anyone have any suggestions or another way to install this application on Linux? ...or am I missing a step? The rpm is preferred, but anything that works would be great.
MySQL Administrator Tool
I'd like to use MySQL Administrator application remotely from home. Possible? Will I have to open up port 3306? If so, is that safe?
MySQL Catalogs Not Listing In Administrator
I have mysql 4.1 installed and working well. The problem is that neither Administrator or Query Browser will list my catalogs. The catalogs exist and I can run queries against them using php. Any ideas on what is causing my catalogs to not show up?
MySQL Administrator GUI Running Slowly... WHY?
We have created an instance or schema that contains over 14000 tables. It is a lot of tables. When we attempt to browse the tables in the GUI it literally takes 5 minutes or more for it to come back. Granted when using the Microsoft SQL Server Management Studio it is slow but doesn't take that long. After about a minute or so it gives the list and is kind of slow to scroll. Can this be fixed by optimizing the database? Is this just too many tables for mySQL to handle?
Administrator Stopped MySQL Server
I installed MySQL 4.1 on my Windows XP Pro system and started using it with the command line client. I didn’t like that and downloaded MySQL Administrator (I have yet to download the MySQL Query Browser). I went to the online documentation and I came to the section on configuration and noted that the de-bug component was not enabled. I clicked on it to enable it and a window popped up that said I could use the Stop/Start Service feature so that the component would take effect. I clicked on Stop Service and the Administrator stopped the MySQL Sever, but when I clicked on the Start Service I got a message saying that the service could not be started. I recycled the computer and no change. I went to Services in the Administrative Tools and attempted to start MySQL Sever, but that would work either. Can someone tell me how to get MySQL Sever running again? I’ve spent the whole day on the web looking for answers and can’t find anything useful.
Can You Import/export Using MySQL Administrator?
We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I need to know else (e.g. Navicat)?
MySQL Administrator On A Remote Machine
On my internal network i have mysql running on a test/development webserver (windows), and im trying to use the GUI tool MySQL Administrator on another networked pc but it wont work. It keeps saying 'Error 1045 Access Denied....' I can ping it fine, and MySQL Administrator GUI works on the server itself.
MySQL Administrator Remembering The Password
I have MySQL installed on a Windoz2000 platform and I'm using MySQL Administrator to manage the thing. Until recently MySQL Administrator would remember the StoredConnection, ServerHost and UserName but the Password box was always blank and needed me to enter the password each time I started it up. This was fine. However it now remembers the password as well ! & this is NOT good. I can find no way of getting rid of the password from the dialog box or telling MySQL Administrator not to remember it. There must be a setting somewhere that I've inadvertently flipped - but I can't find it. Any ideas ?
|
TRACKER
