MYSQL :: PDA Client Or Access Sync Tool?

PDA Client Or Access Sync Tool
I have a software application with an Access front end and an Access backend
to house the data. Recently I converted the backend to MySQL. The Access
frontend works fine connecting to the MySQL backend.

The issue I have now is that I also have a syncronized database on a PDA. I
was using ActiveSync and Pocket Access to create the database on the PDA and
keep it syncronized with my PC (backend) database. I'm using eVB programs
to retrieve and update the data on the PDA, then all I have to do is sync
the PDA with ActiveSync and it will update my Access Backend database
accordingly and vise-versa.

If that is not an option, on the PC side, I could keep a
replicated/synchronized Access database using a third party app (like
Access2MySQL Sync). I would still keep the MySQL backend, but also have a
replicated/syncronized Access database strictly for use with my PDA. This
would allow me to keep my ActiveSync & Pocket Access synchronization
process. My problem is I can't find a third party app that actually works
well enough to put into a production environment.

MySQL GUI Client Tool
I am looking for a gui-based open source client tool for mysql. Does anybody have any suggestion besides those listed in the first few posts in the beginning of the forum?

Alternative Tool For MySQL Command Line Client
Can you name a good Alternative tool for MySQL Command Line Client.

FREE Tool To Synchronize MySQL And MS Access (or Other ODBC Sources)?
I'm hoping to find a free tool that will enable us to synchronize an Access database(s) with MySQL or PostGre. We have to use Access b/c our GIS software will only directly edit data stored in Access or flat files. But I'm also wanting to backup our data in a MySQL database so we can take advantage of its back-up capabilities.

So for the most part, most of the synchronization would be one way (Access to MySQL). We'd only want updated or new Access data to be updated/added to MySQL - so a standard converstion tool probably won't meet our needs. Eventually, we may want to update/add data directly to the MySQL and then update/sync the Access database(s).

If there are no free tools available, do you know of any low cost tools? How reliable are they?

My Client Needs Access
i am brand new at this. just built my first oscommerce store for a client. the customers upload up to 50 photos on this site and my client needs to be able to get into the database and retreive her files.

she has a username/pass but i cannot figure out how to set her permissions! everything is hosted through godaddy and they are not really big on help.

Client Access
I need to run client programs which access a database over the internet (or . Has anyone any experience with this. In particular I'm interested in the performance as compared with access within the local network.

Client To Access An SQL Database By Visual C++
I have several problems. I am trying to communicate with a
sql database(local) by Visual C++ 6.0 (MFC based aplication).
Well i think i am able now to connect to the local sql-server,
but i cannot send commands to the sql-server, as create table...
or things like that. I searched the Internet but only found source code
for C. Well, but i need some for C++ .

How Do I Setup The Server On A Network Drive For Client Software To Access?
I'm building a database system for our department at work and have successfully installed the MySQL Server 5.0 to my local machine and developed my user interface to access it read/write/update, etc. just fine through VB6 and the ODBC driver.

My problem now is how do I get the database files and server functions moved/transplanted/installed on a network share drive (Windows 2000) that my peers and I have access to, so that I can deploy me client user interface onto their machines so we can all access the database across the network and I can get the files off my local hard drive?

Remote Access Not Working: Error 1251 Client Does Not Support Authentication Protocol Requested By Server
I'm trying to set up my MySQL database for remote access. I've never been a DB admin so this is all mostly new to me. I am binding to my public IP address, and I have created a new user with the following grant commands run from the mysql command line on the server:

mysql> grant all privileges on prs_data.* to 'username'@'%' identified by 'change';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on prs_data.* to 'username'@'localhost' identified by 'change';
Query OK, 0 rows affected (0.01 sec)

When I try to connect remotely from another host, here's what happens:

Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client In
I have recently upgraded to MySQL 5. Got this error message in my IE Browser. Have read some of the comments on other forums and my choices are: Upgrade all client programs to use a 4.1.1 or newer client library, or

SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd')

Can someone please advise?

Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
Basically I am setting up php,mysql and apache to run an application. While trying to connect I get the following error:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:sudhirapachehtdocssvgmap est4.php on line 14
Cannot connect to the database.
Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have tried the following message posted earlier by many of you guys i.e
"SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something')
flush privileges

I am trying this from a long time and do not find a way to fix this problem
I request you guys to help me in soughting this out and I appreciate your patience in reading my post.

Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error.

Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?

Bdb-no-sync
What are the implications of setting the "--bdb-no-sync" flag when
using the BDB storage engine. There isn't alot of documentation on
this. I have searched google and docs. If there is a resource that
someone can point to, it would be helpful.

Does this mean that after every transaction, sync will not be called?

When will sync be called then?

Will setting this flag lead to "ACI" semantics, ie no durability? If
so, when will transactions become durable?

Will setting this flag increase the likelyhood of DB corruption? As
happens in Postgresql with fsync off.

I know in BDB (non MySQL storage engine), setting "DB_TXN_NOSYNC" on a
BDB transaction leads to ACI semantics. It is then up to the app to
call DB->sync when it wants durability. How does this map to the
BDB/MSQL storage engine?

Sync 2 Databases
I've recently ran into issues with my web hosting server (not in house) so I am wanting to set up a local machine with an exact replica of information from the hosting server. Is there any function or "simple" way to sync 2 databases on different machines - outside of manually updating them? I have to perform this operation once or twice an hour so manually updating the information is gonna get bothersome real quick.

Two Tables Out Of Sync
I'm new to databases and am experimenting with mysql.

I have a clients table and a sales table in a mysql database.
Client_id is the primary key in clients and a secondary key in sales.

The only client_id's that show up in the clients table are client_id's
starting at 28 (they autoincrement from there).1-27 were old ones
that I used in testing.I added a new client and clients shows the new
client_id as 188 which makes sense.I added a new sale to the sales
table for this client.

But in sales the client_id is set to '1'. Why isn't it 188?
Probably '1' was the original test client_id and had the same data.
The database seems to have remnants left over from past deleted
records from the clients table.

Does anyone know what's going on?Is there something like a 'pack' or
're-sync' command in mysql?

Hosted Sync
I have 2 mysql database, the first is mysql from hosting company and the second is mysql hosted on my computer.
What i have to do to syncronizing both database.

Sync Databases
I have a database on a production server, and a seperate one on a development server. Up until now, I have been doing a mysqldump on the DB on the production server, SFTPing the file to the development server, and then running mysql dbName < filename.sql
is there an easier way to do this? I guess I could use a shell script, perhaps including some expect for the remote server work. But is there anything either builtin to MySQL or as a simple third-party tool which, without creating a temporary file, copies the database from one server to another?

MySQL Sync
i have 2 mysql tables on 2 different servers with the same table structure - i want to be able to sync up some tables within the databases.
I am getting very stuck with this and in need of some help.
I keep reading about cron jobs and this sounds like its something i need to get set up, but then i need a script to run.

Incremental Sync Of Two Db's
I have two db's. One on a local server, one on a remote server. Both
are running MySQL 4.0. The remote is a production server that I run
mysqldump on nightly to backup the prod data. The local server db was
created with one of the production dump files, but I'd like to
automatically update my local server with the production data on a
nightly basis.

How can I sync them up? Keep in mind that it's a one way street,
meaning, I cannot make remote connections to the remote db from the
local db. I can however make connections from the remote db to my
local db.

Mysql Table Sync
Can a MySQL table sync with a MSSQL table?

Commands Out Of Sync Administrator
When I try to create a table using MySQL Administrator I receive the following error:
"MySQL error number 2014
Commands out of sync; you can't run this command now"

Most of the other posts refer to running multiple queries at the same time, but this a development resource so no other queries are being run, unless there is something going on in the background. I'm a basic/beginning user.

I know how to run queries and update data, but as far as advanced/custom installations I'm out of my element. This is a recent installation of a XAMPP package on a Windows XP platform, which included Apache 2.0, PHP 5.1.6, MySQL 5.0.24a. I am using MySQL Administrator 1.2.4.

Commands Out Of Sync Message
I'm having a problem wherein I unexpectedly receive a "Commands out of sync" error message. I'm using the C API for MySQL 4.0.21 under Linux. The basic flow of my program looks something like this (parentheses indicate the function that the commands are taking place in): Code:

Sync Mysql Databases Over The Web
I would like to have two mysql instances syncing with eachother over
https. So I dont want to do any tunneling or have any ports but 443
open.

Quick & Easy MySQL Sync?
Does anyone know of any quick and easy way to sync a local development mysql server to a remote server and back. I'd like to be able to optionally sync either direction?

How To Track Error - Commands Out Of Sync
We are currently running about 50 databases on MySQL 4.0.14. Occasionally
our users will get the error:

Couldn't select database. Message: Commands out of sync; You can't run this
command now Message Number: 2014

When this happens to one customer, it affects them all. We end up having to
restart the MySQL services to clean things up. Our goal is to eliminate
whatever is causing this, but cannot determine the cause.

I have checked the online help on MySQL and we are not calling the functions
normally associated with the error.

Error 2014 - Commands Out Of Sync
I am seeing this error message when running my php scripts, and have no idea what it means!

The error reporting just "says error 2014, "Commands out of sync", "you can't run this command now".
using php 4.3 and Mysql 4.0.20d.

Sync Databases For Replication Without Stopping The Master
Teh replication breaks every couple of months and the problem is that the server can't be stopped since it's a high volume transactions application. So is it possible to set the replication without stopping the master server? If yes, then how? If not, then what shall be done?

ERD Tool?
I need a good ERD tool for reverse engineering a few databases. It must be able to properly reverse engineer the foreign keys and create the entity relationships for InnoDB tables. (The fabforce product does not, for example, or at least I can't figure out how to make it do so) Free is preferable, but commerical/licensed products are okay too.

Migration Tool Kit
I'm new to MySQL and cannot get a connection to my database at my ISP. My ISP is lowesthosting.com they use an Apache Server. I've tried to connect using the dns # 207.44.216.56. I've also tried using my FTP address and I cannot get a connection. I get a message in the details that it will not recognize my password. I know I'm doing something wrong but can't figure out what?

Looking For Encryption Tool
I have a prospect that needs to collect sensitive personal data via the web
for mortgage applications. A certificate & SSL seems to protect the data
from the browser to the server, but I need some way to encrypt the data for
storage in mysql and (possibly) into a flat file for retrieval by the
prospect. I have not been able to find a simple solution for this
compatible with BSD and Apache.

Stand Alone SQL Tool?
i have been using SQLyog 2.5.1 for my sql administration during development. i went back onto their site to see if there were any updates and realised that they were on 3.5 and you had to register the software! (2.5.1 was freeware).

Migration Tool
I'm new to using the Migration Tool and don't know where to look for help, so I posted here rather than the Migration Tool forum.

What I am trying to do is get data from a high-traffic Oracle server over to a local MySQL so I can dissect and analyze the data with large amounts of data (with temporary query space too big for MS Access). In the migration tool is there a way to do the following:

On the Oracle Server:
- Select ACCOUNT_ID, CALL_DATE, CALL_TIME, CALL_RESULT from DATA_REPOSITORY.ACCOUNT_CALLS where CALL_DATE >= TO_DATE('07/01/2007','MM/DD/YYYY') and CALL_DATE <= TO_DATE('07/31/2007','MM/DD/YYYY')

On the MySQL Server I want to migrate it into a local schema/table called LOCAL_PROD.CALLS_200707.

The major things that I want to do here is only select the 4 fields I need out of the data repository, and I only want to do a month at a time since there is usually ~27 million records per month with data going back all the way to 2005 and I want it split up for faster querying and right now I don't care for anything before the last couple of months.

Is this possible using the Migration Tool? I can connect to the Oracle DB and local MySQL fine. However, when I try to mess with the SQL statements under the Advanced options and Apply Changes, it looks like everything is going fine.

However, the WHERE statement will go away during the Bulk Transfer and the process will still try to take the entire contents of DATA_REPOSITORY.ACCOUNT_CALLS and create a DATA_REPOSITORY schema on the local server and try to put the entire contents in a table of the same name. I'm open to other suggestions if the Migration Tool is not made for that kind of functionality.

MySQL GUI Tool
I just downloaded mysql but i would like to use a tool that would let me create/drop/alter tables , delete, add files etc.

Which tool do you think is the BEST one for this?

Migration Tool Kit
I'm trying to get the migration tool kit working. (i'm a programmer.) I don't understand the target source part.

I found this link:

http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-targetdb.html

I can connect to a sql server. i'm trying to migrate my sql db to a local mysql db. However, i don't have a username or password. (I do have localhost started. I run IIS without usernames or passwords.)

is there a prior step i have to take that sets up a user and password so the sql migration tool kit can run?

Migration Tool
I am using the Migration Toolkit
In the script it generates, it has a drop command that drops the tables whenever I transfer any new ones over.
Anyone know how to change the settings

Php Admin Tool
I recently upgraded from phpmyadmin 2.5.0 to 2.6.3-pl1. I cannot find the functionality to 'load text files into tables'.

Report Tool
Is there any MySQL reporting tool that is open source and doesn't require programming knowledge? I need a front end for MySQL that will allow a user to input a couple parameters and will produce a report, including graphs. I haven't been able to find an adequate open source solution for this.

Graphical Tool
I'm building my first MySQL database and come into trooble when trying to
create constraint integrity.
I'm trying to get it work by hand (notepad) but thing that it would be
better to create the tables using a graphical tool, but I can't find any for
MySQL.Please help by giving me URL's for graphical tools (if possible free) that
manage constraint integrity.

Graphical Tool
I'm building my first MySQL database and come into trooble when trying to
create constraint integrity.I'm trying to get it work by hand (notepad) but thing that it would be
better to create the tables using a graphical tool, but I can't find any for
MySQL.Please help by giving me URL's for graphical tools (if possible free) that
manage constraint integrity.

Database Design Tool
is there any software to draw a database design with his relationship for mysql?

Mysql Optimization Tool
Is there any tools that you can just run on your server that will automatically optimize your mysql database? Like to speed it up,clean it etc.

Where Can I Find 'crash-me' Tool
I remember I could find and use 'crash-me' tool on the mysql.com site.
It was very nice to compare mysql with other database products, although not neatly arranged with too many details.
Now when I go to the place (http://dev.mysql.com/tech-resources/crash-me.php), it says:

Note: The crash-me table is normally generated from DBMSs started with default parameters. If this is not the case, the fact is noted in the comment row.

I can I access and use the tool to compare the features of each databases?

Good DB Modeling Tool
I'm wondering which tool you guys recommend for creating a database model. This will be used for MySQL and possibly SQL Server 2000/2005. Also, I'd like to have the capability to reverse engineer my diagram to create the appropriate SQL code. Price isn't much of an issue if such software must be purchased.

Regarding Mysql Front End Tool
could someone please suggest me any mysql front end gui tool which covers features of MySql 5.0.3 beta including stored procedures, views and especially triggers.

Stored Procedure Tool
I'm using mySQL 5 and i'm trying to create some stored procedures.

Does anyone know what do I have to do, to make "MySQL Query Browser" works like if i was using the mySQL console ?

Cause, when i try to run this code at the "MySQL Query Browser" or another mySQL query tool:

DELIMITER |
DROP PROCEDURE IF EXISTS sp_declareG|
CREATE PROCEDURE sp_declare (P INT)
BEGIN
DECLARE x INT;
DECLARE y INT DEFAULT 10;
SET x = P*y;
SELECT x;
END|
DELIMITER ;

I get several errors. BUT, if i paste this inside the mySQL console it works FINE ! What do i have to do to make "MySQL Query Browser" works just like the console ?

Case Tool For Mysql?
the version of erwin i have does not support mysql. is there a gpl-type
case tool for mysql?

Problem With MysqlAdministrator' Tool
when I first time to login database via 'mysqlAdministrotr' with user 'root', it does not work. Then when I close it, the error message comes out like this

'Exception EAccessviolation in module libmysqladmin.dll at 000013d8
access violation at address 00AC13D8 in module 'libmysqladmin.dll'. Read'.

MySQL Diag Tool For XP
I have MySQL v5 installed on my XP PC. MySQL is used by another program on the same PC.

Currently this other program, which I create scripts with in its' native scripting language and run within the program, is coming back with an error that says Error: Table is Read Only.

I have used the MySQL GUI admin tool to look at the database that this program uses to see if I can see anything wrong, but it all looks OK.

Is there a tool I can use to try and write/access the tables within this programs MySQL database so I can try and identify the offending table and maybe fix the problem.

MySQL Migration Tool
how trustworthy and capable is the Migration Tool? If it says everything went smoothly does it mean that everything went smoothly? Just a little example, Access stores dates on the background in US format although it displays it to me normally in EU/Dutch format (day-month-year). This I could easily check to see if it migrated things well because I'm aware of this issue with Access. But are there any pitfalls I should look out for with this migration tool? Not sure if others have experience with it.