MYSQL :: Remote Control

Local Remote Command Control For Mysql?
ok, My website is hosted remotely onto my Web Hosting company. and i want to control MySQL remotely or locally in my computer without using PHPMyAdmin.

I notice using PHPMyAdmin is very tiresome and also i'm thinking
if there is a good alternative for PHPMyadmin so that i don't need
to enter my CPANEL website everytime i do the work using PHPMyadmin.

I'm thinking perhaps just like Microsoft Express/Outlook functionality instead of opening my Yahoo emaail account they will be sending the incoming and outgoing messages into my email automatically. This are the features that i'm looking for as an alternative for PHPMyAdmin.

MySQL Remote Backups - No Access To FTP Or Remote Command Line
I have a mySQL database located on a remote host's server. I would
like to schedule a task on my local Windows computer to retrieve a
backup/dump of this remote database.

I have contacted my host, and they indicated that the server is only
open to the Internet via mySQL. Therefore, even if I did have access
to that server's command line (which I don't) to create dumps via
mysqldump, I would not be able to retrieve via FTP.

Does anybody have any ideas as to how I can generate backup files from
my local computer through a local command-line interface? I have done
it through a GUI (DBTools), but I would like to have it done via DOS
batch, so that I can schedule it. Does anyone know of any mysql backup
GUIs with command line switches? Or can somebody recommend an
alternate means of getting a local backup?

Control Flow
I am having a hard time with Control Flows which is what i think I need to solve my current problem.

Below is a sample query dynamically built based on user screen selections. Notice that it attempts to JOIN 5 tables to fscenario.

My problem is that fscenario.`fsce_comp` may or may not be NULL.
Either way I need the record retrieved if all other criteria is met.

If fscenario.`fsce_comp` is not NULL I want to display the corresponding fcomponent.`fcom_name`.

If fscenario.`fsce_comp` is NULL, I still want to retrieve the record displaying nothing for the name.

Bad explanation, so I hope you follow?

Using the manual (http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html) I have tried several IF, CASE, IFNULL structures. They all return records where fscenario.`fsce_comp` is populated and exclude the records where fscenario.`fsce_comp` is NULL.

I guess I am not understanding how to implement the syntax......

Source Control
Does anyone know if there is a program (for windows) that can help us catalog our sprocs and table setups into source control?

MySQL DB Control
How can i manage my mysql db? Example: How can i learn db size? Phpmyadmin is not installed on my hosting company.

Control Center
I started using Control Center as a GUI for MySQL. Making progress but I could do better if I had the help file. It is grayed out. Is there a place to locate this?

Transaction Control
I am a recent user in mysql and I'd like to know if I need control the transactions in java when I am using mysql. I am asking it because I have read the mysql already control the transactions automatically, that is, it automatically control the commit and roolback commands.

Revision Control
I've been searching the mysql forums and documentation for anwers to this
to no avail..Is there any facility for revision control within mysql? I need to be able to have
snapshots of a mysql database that users can modify, later merging those
modifications in with the main database, similar to branching in cvs.
Does something like this exist already? Is it doable by copying the database
and then logging edit transactions on the copy? What about using the storage
engine plugin for tracking modifications?

Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I
cannot seem to display more than 1000 rows in my result set when I know that
there is 1534 rows. I know that it is a setting somewhere, but is it in
MySql or in the Control Center somewhere. I am running this on a Windows
2000 machine.

Control Center
Getting the following message when I click on the MySQL shortcut on my desk
top:

Error Starting Program
The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion
numbers.

A device attached to the system is not functioning.
Have gotten both Dll's and stuck em in the system and program directory...
nothing happening there.
Would like to find out what "Rtlgetntversion numbers" is all about.

Control Panel
i'm having some problems with my MySQL install. Firstlty when I installed MySQL I never got an icon of any kind within the control panel. I've been looking at tutorials of how to create a database and many of them use the control panel option as a starting point but I can't because MySQL is not present within the cPanel. Also when I click on the MySQLadmin.exe in the bin it does not open probably. It opens briefly- shows a black screen with decending text. It then dissappears completely after several seconds. It cannot be seen or opened in the tray

Control Max Time
Does anyone know of any parameters that can be set to control the maximum time limit mysql will allow a single query to run before timing out etc?
Rather than let badly written queries run for long periods I would like to just abort them if they exceed a set amount of time.
I know the php calling script should/could handle this with defensive coding etc. However, I'm not always in control of how other users write their scripts that interact with mysql.

MySql Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I
cannot seem to display more than 1000 rows in my result set when I know that
there is 1534 rows. I know that it is a setting somewhere, but is it in
MySql or in the Control Center somewhere. I am running this on a Windows
2000 machine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=...sie.nctu.edu.tw

Mysql Control Center
I'm trying to get the GUI to connect to a remote mysql database from my
client machine. What is the proper syntax for this in the GUI? I have
tried everything with no luck: using the ip of the host, using the complete
dns hostname of the host, using root as the user, using root@hostname as the
user. I keep getting access denied for every attempt. I'm sure I am using
the correct password.

MySQL Control Center
I can access my MySQL database with MySQL Control Center from a computer with a direct connection to the internet, but I can't do it from my other computer on a network. Is there a way to use MySQL Command Center through a network/router? I'm unable to find any connection settings options in the program.

Start Control Center
Getting the following message when I click on the MySQL shortcut on my desk
top:

Error Starting Program
The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion
numbers.

A device attached to the system is not functioning.

Have gotten both Dll's and stuck em in the system and program directory...
nothing happening there.
Would like to find out what "Rtlgetntversion numbers" is all about.

Retaining Control From MyODBC
I'm developing a system with an Excel front-end that uses ADODB and MyODBC to fire off instructions to a (local machine) MySQL server. As I step through my VBA code, it sends an instruction to MySQL (e.g. gconMySQL.Execute "DROP TABLE IF EXISTS MyData;" ), waits for the instruction to be executed, before returning control to the code and moving on to the next VBA statement. All well and good; this works fine for the majority of the processing.

However there is some initialisation of the MySQL database, particularly loading some data tables into MEMORY, that takes up to half a minute to complete. I'd rather fire off the instruction(s) to MySQL to do this so that MySQL initialises invisibly in the background, whilst the user continues playing around with the front-end themselves.

MySQL Control Center
I have installed MySQL Database Server 4.0 and MySQL Control Center, but i can't still use MySQL CC to create new database or other feature.

MySQL Control Center
I am trying to install MySQL Control Center for the first time (the latest
version). I am using Windows XP. When I try running the setup routine, I
get through all the prompts and when it starts to install, it gets stuck at
the 'Initializing... ' screen. And it does not go any further. I cannot
even cancel. the operation.

Mysql Control Center
Quote: ERROR 1109: Unknown table '1' in information_schema
Quote: [stuff] ERROR 1146: Table 'cdcol.1' doesn't exist
Quote: [stuff] ERROR 1146: Table 'mysql.1' doesn't exist
Quote: [stuff] ERROR 1146: Table 'webauth.1' doesn't exist

I get that error when ever i try to access any tables in mysql control centre. The error is almost the same, except for the database name. It does this even on a clean install.
Im using xampp

MySQL Control Center
how can i declare a Vendor-Specific
attribute in MySQL Control center. In the regular radius i declare it
well.
I check the radtest and its write : radclient:WARNING: Malformed
RADIUS packet from host 10.0.1.16: Vendor specific attributes do not
exactly fill Vendor-Specific

How To Control Mysql In Hosting Server
I am a ASP programmer. I use MS Access for quite some time, and I am to switch to MySQL.

The way I use Access is create tables in my computer and upload it. When I want to do backup, I will download it and make another copy locally.

1. How to create a MySQL DB and Upload it?
2. How to modify the DB structure? For example, create index for certain field? do I have to download it and change it locally?
2. How to download and make backup?

Varables In Control Flow Statements
Is it possible to assign values to variables in a 'SELECT IF ' statement:
when I execute a statement like,

SELECT IF(col1> col, @x:=3, @x:=4) AS ,@x/2

I get a blob for @x/2

Solution For 'repetition Control' (slideshow App. For Web)
Im currently developing a web portal wich will serve, as part, as a customizable slideshow presentation.

The user will have the option to select multiple galleries of images of different subjects, each gallery containing several images.

The slideshow's 'playlist' function plays a certain number of images from one gallery then moves on to the next on. I.e., the playlist have 200 galleries, and will display 5 images per gallery.

Its imperative to the system to have a 'image repetition free environment', to assure that, when a gallery that was previously displayed shows up again in the playlist, the next 5 images of that gallery wont be the same as the ones previously played.

Code:

Could Not Connect To The Service Control Manager
I'm trying to run MySQL Server 4.1 on Windows Vista Beta 2. I was able to install the server before. But when I uninstalled and tried reinstalling, I got the following message at the end of the Instance Configuration Wizard:

Could not connect to the Service Control Manager

I got this message once before when I first tried to install MySQL on Vista Beta 1. Can anyone help me diagnose the problem?

Current Version Of Control Center
What's the current version of the CC? I have only 0.9.4 beta, and I would like to use a release.

Control Center Confusing Hosts
I've got control center installed on my localhost machine where I piddle around with db's on my machine. Today I attempted to connect to another server to assist others in their db work. I inserted xxx.xxx.x.xx for my IP address (obviously I'm susbstituting my actual IP) and when I selected "text", I was echoed back the string:

ERROR 1045: Access denied for user: 'xxxx@ooo.ooo.o.ooo' (using password: YES)

The complex issue is this, I inserted xxx.xxx.x.xx as my host IP, but instead of using my host IP to test the connection, control center used my localhost IP.

Permissions In Mysql Control Center
I need to allow 3 different servers to access my MySQL Server. How do I do this? Also, I was told that having MySQL configured so it doesn't restrict access is bad - how do I make sure that's not the case?I feel like I know what they're saying, but I don't know how to actually implement this in the Control Center, and I must be using the wrong keywords because when I look it up, all I find is stuff on how to connect to the MySQL Server from my web page using php (which is what I'm using and already doing).

How To Control Number Decimal Places Displayed?
I would like to select the value of a decimal(7,2) column and display it as either int or decimal(7,2), based on the value of another column.

It seems that either the cast or the format function should do that for me. But both functions seem to require a constant for the second argument.

select format(m,2) from foo; # works
select format(m,sf) from foo; # error

select cast(n2 AS decimal(9,1)) from foo; # works
select cast(m AS decimal(9,sf)) from foo; # error

It seems strange to me that these functions demand a constant.

How can I accomplish this? Do I have to convert to string and use string search and replace functions (ugly).

ERROR 1045 When Testing In The Control Center
In the MySQL Control Center 0.9.4-beta, I right click the top level server name and choose the Edit option. Then I have entered a User Name and a Password in the General TAB. I then mark the option "Promt for Password" and hit the "Test" button.

I get a small window where I should enter the password for User name@Host name. I enter the password and hit the OK button. Now I get the error message "ERROR 1045; Access denied for user; 'User name@Host name' (Using password: YES)"

When looking in the Help menu, the Contents - F1 is not activated, so I can't get any online help.

I'm just wondering why the test for the password failed and why there are no online help in the consol?

Importing Tables Using MySQL Control Center
I am using Dreamweaver MX to create a data-driven web site. With the
VPS hosting plan we're on, our remote FreeBSD server only supports the PHP
application server. PHP requires MySql. Thus, I installed a copy of MySQL
Control Center 0.9.2 beta. (I prefer a GUI and not command prompts unless
necessary.)

The information I plan on using in developing this site will be derived from
a contact management program called GoldMine. The records will be exported
into DBase tables, and somehow imported into the MySQL/PHP/Dreamweaver
environment.

From what I can gather so far, the MySQL environment I'm working under will
not work with Access or DBase tables. Thus, I've created a new table in
MySQL and re-created the various fields to match what I have in the DBase
table. Now I want to import all the records I have in my DBase table. In
fact, I will need to update the MySQL database weekly.

So far, I have been successful in making all the connections work, except
for importing the table into MySQL. In the MySQL Control Center, once you
connect to the database, there is an option to import, but it is dimmed out.
How do I make it work?

Exporting Tables With MySQL Control Center
I'm using MySQL control center and I'm trying to export tables. The only option that I've seen to export these tables is to right-click on each table but that option is grayed out.

Speeding Up Boolean Search Control Syntax
When doing a FULLTEXT search on a table I have noticed that on average introducing wildcard boolean search control syntax slows down searches by up to 10-20 times longer than without it. For instance, if I want to search for both "keyboard" and "keyboards" so I perform a match against 'keyboard*' then just making that "s" optional takes my previously 0.08 second query to 2.6 seconds.

Is there any way to speed up MySQL 5.0 so that such simple touches for improving result relevancy doesn't cause such a drain on the server and our visitor's patience?

Access Control Via A Role Based Security Model
I am trying to develop a web based database application to manage a Scout
group. I need to control the level of access different visitors to the site
are allowed to different parts of the database. I need to provide public
information, including some contact details from the database, to
unauthenticated (non-member) users and to provide a scale of access to more
information for authenticated members.

The access model would be similar to the following:

Role name Access
public group leader contact details
member read own details, update some details, read contact
information for all other members
leader as for member plus update youth member progress records
mmbrship secy update financial details for all members
group leader access all areas

The mySQL manual shows this can be managed by granting privileges to
individual users based on columns in the various tables. Can I do it using
a role-based model where I assign one or more of the above roles to a user
and grant the privileges to the role?

Downloading Export Plug Ins For MySQL Control Center
Does anybody know where I can download Export plugins for MySQL control center. I looked on mysql.com but I couldn't find anything.

Control Center "lost Connection..." And ByteFX
I'm currently trying to move from MS SQLServer to MySQL, running on
windows XP.

When trying to connect to mysql on localhost with mysql control center
I get the 2013-error "Lost connection to MySQL server during query".

I can connect from command line. If I do so, and change passwords by
using OLD_PASSWORD('<password>'), control center runs nicely, but then
ByteFX fails to connect with "Access denied for user...".

If I set the passwords with PASSWORD('<password>'), ByteFX runs
nicely, but Control Center fails.

Control Flow Issues ("CASE")
I'm not sure how to do what I need to do, here. Basically, I need to do a query that results in a number, then based on that number I need to run another query that returns a recordset. In a nutshell:

SELECT CASE
WHEN (SELECT MAX(LENGTH(a)) FROM A)>0
THEN (SELECT b,c FROM B ORDER BY b)
ELSE (SELECT c,d FROM C ORDER BY c)
END

What Has Replaced The "Control Center"
I used to work with the so called Control Center but that seem not work with the current version of MySQL. With the "Administrator" I don't find any functionality to enter data into tables. I really miss that functionality. Is there no other way than writing INSERT statements with SQL? What program can I use for that purpose?

Remote Connection
How do i connect to a remote (webserver) Mysql from the windows command line?

Remote Access
I have a MySQL server running on my iMAC and am able to access my databases locally. What steps do I have to do to allow access from a remote PC thru TCP/IP ? The manuals say it can be done but don't specify what is involved.

Accessing Remote DB
i want to inser data into a remote dB. I cant for the life of me get it to connect. The mysql_connect syntax is straightforward. Ive tried the ip number and domain name, the user name and pass are correct. No firewall probs.

Always an error lilke this:
"Can't connect to MySQL server on '130.220.33.14' (10054)"

I use phpdev to run the files at home. Is there maybe a config I have to change on it to access remotely?

Remote Mysql
I'm having a weird problem and hours of googling could not help me solve this, so maybe someone here can help me out? I'm by no means experienced with mysql, it just worked all the time so I didnt have to bother looking into it too much :)

We have 2 servers for our forum, one "powerful" server used as webserver where phpBB runs on, and one server that just holds the database (we got that after we found that code & database on 1 server caused overload).

So far, everything went fine for nearly a year now and I had nothing to do with all of it, all I had to do back then was edit a variable on my.cnf on the database-server I think, and then it worked.

Now the webserver's power unit broke, and after that the database had all these little errors on several tables, so I went to phpMyAdmin, marked them all and clicked "repair" - probably/like/surely a stupid move [my excuse: i was tired & in a rush as I did this from work] as the tables were rather big in size (several hundred mb). As expected, the forums didnt work during that, all I got was the typical phpBB "could not connect to database"-message. This went on for ages without anything happening, the tables just stayed "in use" (I could still connect to phpMyAdmin afterall).

After it wouldnt work, I restarted mysql, i restarted the server - those tables still stayed in use, so I flushed the whole database and installed a backup into another database, changed forum-configuration to read from the new db and thought things would be fine, but they weren't.

It just won't connect to mysql it seems, at first I thought some table must be still corrupted, but after some trying out, I realized that the database/forums DO work when being addressed as "localhost" from phpBB-files running on the database-server. When I change the configuration to connect via the IP of the server instead, it will give me the "Could not connect"-error just as it does when I try to connect from the webserver.

I checked netstat on the db-server to see if the the mysql-port was open and being listened to, and got this:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

this does mean it's theoretically working, right?

I also tried to grant all priviledges again on mysql, but didnt change anything either - do you have any idea what I could do? This is driving me nuts (especially as I can see the forums running fine when connected to by localhost).

As I said - this happened suddenly and has been working before for nearly a year, that's what puzzles me most, I didnt change anything on that server mysql runs on!

Remote Connection
How do i connect to a remote (webserver) Mysql from the windows command line?

Remote OUTFILE
I have three servers (S01,S02,S03)... my aplication PHP run in S01 and there are two databases in S02 and S03.

I make one file and I'm using LOAD DATA LOCAL INFILE INTO tbl_xxx to load file in S01 to S02.

My problem is:

I need export data from S03 to S01 using only mysql.
I'm using SELECT OUTFILE, but this statment is only local.

is it possible?

Remote SQL Connection
I am trying to access my database on the server with a MYSQL front-end
client on my computer (not the server). I have the correct username,
password and database name. I tried every possible hostname, even its ip
addy, but each time, I am rejected by the server, which says something
like - access denied. I can access the database in my php code with
'localhost', but that's of course because the code is actually running on
the server. Is there anything I have to specify on the MYSQL server in order
to gain access to it remotely?