MYSQL :: Building A Db On Another Server From A Linux Machine

Can't Connect To MySQL Server On Local Machine
am following along in Head First's PHP & MySQL book, at chapter 2. I've downloaded PHP, MySQL, and Apache. A couple basic scripts have worked fine, so I know PHP is working. I can create a table and a database in MySQL throught the command line window, so that seems good. But I'm trying to execute an INSERT function on the example table that the book had me make, using a script, and I'm getting "Error connecting to the MySQL server" which is the or die error message I used for failure to connect.

In setting up MySQL, I was prompted for a password but not a username. So I'm trying to leave the username data blank in the mysqli_connect function. I wonder if this is my problem? I've looked through my.ini but to my untrained eye it's all Greek and I can't spot usernames or passwords there, or in any of the other .ini files in the MySQL folder. If I need a password, can anyone tell me how to find out what it is? Here's how I wrote the connect function (username is blank, surrounded by single quotes):

$dbc = mysqli_connect('localhost', '', 'password_here', 'databasename_here')
or die('Error connecting to MySQL database.');

View Replies !

Exporting From PhpMyAdmin On Server To MAMP On Local Machine
I thought that transferring the database from the server to my hard drive and working with it using MAMP would be fairly simple, but I am lost on the options and get:

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 22, 2008 at 11:02 PM
-- Server version: 5.0.27
-- PHP Version: 5.2.1
--
-- Database: `trumpet`
--
-- --------------------------------------------------------
--
-- Table structure for table `articles`
--
CREATE TABLE `articles` (

... etc. ...

) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =15;

MySQL said:

#1046 - No database selected

Could someone give me some guidance on how to get the database to my hard drive so I can develop locally rather than via the internet?

View Replies !

Connecting To A Remote Mysql Server From A Java Application On Another Machine
i've a java application on a (remote/network) machine and mysql running on my local pc.other users who have access to that remote machine must be able to run that java application which will have to get data/send data to the server(/DB) on my local PC. i was able to run the application when its on my local pC using localhost in the connection string. But, now how do i set the connection string so that the java application accesses the DB (/server) from my local PC?

View Replies !

Copy/move Mysql Data From Local Machine To Remote Server Database
I have an website that is host on web server and here have a database that have only one table name is "user" Table fields are:
name
Id no
email
phone

And I am using same site in my local machine. I always use my local machine for data entry and everyday end of the day I want to transfer data by clicking one button from my local machine database table to my remote server website database table.

How can I transfer data from my local machine database table to my remote server website database table.

View Replies !

In My Linux Server
What is the default server SQL mode when My SQL 5.0 is installed? Is there any available modes.

View Replies !

DML Of On Linux Server
We have MySQL 5 installed on Linux server.

If I defined a table and fields in mixed cases, the table name will be stored in lower case, how about the fields?

In the case of SELECT, UPDATE or other DML, do I need to use lower case for the table name and field names?

Or do they matter?

View Replies !

MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to
connect to database
I used different GUI like "Toad for MySQL"
in connection page I put Linux IP address as "Server host" and
username/password I keep getting error:
Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061)

My question is: Do I need a client installation or configuration on Windows
machine?

View Replies !

MySQL Server On Linux
I have MySQL server running fine on Linux Server(Ubuntu 6.06LTS). I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver on it.
When i try to connect the ODBC allways returns the following error:

[MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql' (11001)

I tried server names like 'mysqld', 'MySQL', ip address, combinations of linux server name and mysql name, and other characters like *.*, *:*, *:mysql, etc...

The MySql server is running fine on linux server, port=3306(default). The 'bind-address = 127.0.0.1' parameter on 'my.cnf' file is marked as comment.

View Replies !

Hou Use MySql On Linux Web Server
Now the problum is that when i Host complete web site to linux server then my all web page is running but i dont no how use MySql database on Net.

Through cPanel i creat MySql database but i cant find database root i m not able to Host or copy my existing MySql database with table which is running on my Computer very fine

So please tell me process

1 have to simply upload my mySql database in Public Html folder or else where
i m using cPanel file manager to upload files

View Replies !

Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error.

[MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server

Is it likely that the windows-linux combination is causing a problem here?

View Replies !

I Can't Start Mysql Server On Linux.
I'm triyng to install mysql server with rpm on a linux red hat 9.0
machine. The installation was succesfully, but now I can't start the
server. I think the right command is mysqld_safe --user=mysql but
during the starting procedure the server shutdown, it reports:

[root@psiche root]# mysqld_safe --user=mysql
Starting mysqld daemon with databases from /var/lib/mysql
040525 09:32:25 mysqld ended

If I try to rebuilt the grant tables using the mysql_install_db it
reports some errors: "asked for 196608 thread stack, but got 126976"
and "to start mysql at boot time you have to copy
support-files/mysql.server to the right place for your system".

View Replies !

Exporting Database From A Linux Server
the following query:

mysqldump web15db1 > sql.dump

where web15db1 is the name of my database.

And i get a syntax error:
Quote:

View Replies !

Importing .sql File In SQL 3.23 On Linux 7.1 Server
I've got a .sql file and was going to import it into mysql.
The file contains around 30000 data but after i've typed:

mysql> source /xx/file_name.sql;

Table of the sql file is created but contains no data. But it poped an error notice without any message:

ERROR: <----like this

the .sql file is version 4.0. Is there any problems on version 3.23 while importing a v4.0 file? If so, could any brother please help on resolving this problem?

View Replies !

Upgrading MySQL On Linux Server
I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting.

I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.

View Replies !

Unable To Connect To Mysql Server(Linux)
i have problem om my sevrer ( linux )
WHM 11.11.0 cPanel 11.16.0-S18450
REDHAT Enterprise 4 i686 on standard - WHM X v3.1.0

after update apache then all websites on server can not connect mysql
from WHM > Tweak Settings > Mysql > 5.0
and used old style (4.0) passwords with MySQLÂ® 4.1+

also command /scripts/mysqlup
but no way still same error can not connect to Mysql

View Replies !

Access Linux Mysql Server From Windows?
Can I run a Mysql server on a linux box, and access the databases belonging to it over a lan from a machine running windows xp?

View Replies !

How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system?

I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator.

Basically, I got caught up in a loop of incompatable modules:

# rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm
warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b
error: Failed dependencies:
perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1
MySQL conflicts with mysql-3.23.58-16.RHEL3.1
Suggested resolutions:
/var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm

If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm.

I will gladly read the "manual" or docs, and would love a pointer to them.

View Replies !

Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup.

The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information.

I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration.

I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.

View Replies !

Building DB: 3 Keys
I want to build the following database
key_1 (int, autoincrement)
key_2 (int)
key_3 (int)
Field_not_relevant (varchar)

The first key is an autoincrement INT. The key_2 and key_3 together should be unique.

Is it possible to define a table that does not allow duplicate combinations of key_2 and key_3? And if so, how?Example:Code:

1, 1, 1, 'bla' (allowed)
2, 1, 2, 'yada' (allowed)
3, 1, 2, 'yada' (not allowed, because 1,2 is same as former entry)

View Replies !

Building Query
My community site has an image upload system with favorites. On the frontpage I display the 6 most favorable images of this week (or rather the last 6 days)
The query I'm currently using is (in simplified form):

SELECT *
FROM gallery_items
WHERE favorites > 60
ORDER BY id DESC
LIMIT 6

This is a little troublesome since I have to tweak the '60' value every few days to make sure that the oldest item selected is about a week old.How can I improve this query to select the 6 most favorable items from this week, and order them by date?

View Replies !

Building Tables
i have not had any issues up till now with building databases playing around...

I was trying to build a user/employee type database and i had the following....

<asset> <employees> <applications> <application environments>

i was trying to build a table such that...

every employee will own an application which both will be part of the application env..

each of those will have assets routers switches servers cars planes whatever that are part of an application env which are part of a "application" which are owned by the employee...

the employee may own more than one of everything..

my thinking is

<asset> <employees> <applications> <application environments>

create table employee (employee key, employee name, asset_key, application_key, app_env key )

create table asset ( asset_key assetname employee_key, application key, application env key)...

View Replies !

I Need Help Building A Query
I need to group 'votes' from one table against another table and then be able to get info on the links from each group. I can't figure out how to group the data for 'sum' then run it against the groups table and populate 3 columns. This is what I have so far:

$y = mysql_query("SELECT item_id, sum(star) AS sum from starsrate_votes group by item_id ORDER by sum desc") or die(mysql_error());
while ($y1 = mysql_fetch_row($y)) {

$b = mysql_query("SELECT url,title,id,category from links where category = '$a1[0]' AND approved = Ƈ' LIMIT 3")or die(mysql_error());
$b1 = mysql_fetch_row($b);
$a = mysql_query("SELECT id,groupname, time from groups where approved = Ƈ' AND category order by time limit 3")or die(mysql_error());

while ($a1 = mysql_fetch_row($a)) {

$b = mysql_query("SELECT url,title,id from links where category = '$a1[0]' AND approved = Ƈ' LIMIT 3")or die(mysql_error());

echo "
<div class="cell">
<div class="list_heading" align="center"><b>$a1[1]</b></div>
<div class="list">
<ol>";

while ($b1 = mysql_fetch_row($b)) {

echo "<li> <a href="$b1[1]">$b1[0]</a> <a href="$b1[2]"><img src="images/info.gif"></a> <a onClick="return overlay(this, 'subcontent')" href="$b1[2]"></li>";
}
The example is at http://websbests.com, it's the 1 row, 3 columns under the Top 3 category.

starsrate_vote

CREATE TABLE starsrate_votes (
id int(11) NOT NULL auto_increment,
item_id int(11) default NULL,
ip varchar(20) default NULL,
dt datetime default NULL,
star int(11) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table 'starsrate_votes'
--

INSERT INTO starsrate_votes VALUES (1, 1, པ.2.249.72', &#55614;&#57159;-05-30 20:54:06', 3);
INSERT INTO starsrate_votes VALUES (2, 1, པ.2.249.72', &#55614;&#57159;-06-02 13:43:57', 5);
INSERT INTO starsrate_votes VALUES (3, 2, པ.2.249.72', &#55614;&#57159;-06-02 13:46:48', 5);
INSERT INTO starsrate_votes VALUES (4, 2, ྀ.1.186.73', &#55614;&#57159;-06-02 13:53:35', 5);

links table

CREATE TABLE `links` (
`id` int(11) NOT NULL auto_increment,
`category` int(11) NOT NULL default Ɔ',
`title` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`approved` int(1) NOT NULL default Ɔ',
`added_by` int(11) NOT NULL default Ɔ',
`reason` text NOT NULL,
`pros` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `links`
--

INSERT INTO `links` VALUES (1, 1, 'http://www.mplonsky.com/photo/', 'Fine Art Photography', 1, 1, 'I decided to submit this website because of the beautiful angels of the photographs, it really takes my breath away.', '');
INSERT INTO `links` VALUES (2, 1, 'http://flickr.mathewvp.com/', 'MathewVP', 1, 1, 'Very Interesting Flickr album.', '');
INSERT INTO `links` VALUES (3, 1, 'http://www.timecatcher.com/', 'TimeCatcher', 1, 1, 'Very pretty photos of the earth we walk on.', '');
and groups table

CREATE TABLE `groups` (
`id` int(11) NOT NULL auto_increment,
`groupname` varchar(255) NOT NULL default '',
`groupdescription` text NOT NULL,
`added_by` int(11) NOT NULL default Ɔ',
`approved` int(1) NOT NULL default Ɔ',
`pos_votes` int(11) NOT NULL default Ɔ',
`neg_votes` int(11) NOT NULL default Ɔ',
`time` int(11) NOT NULL default Ɔ',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES (1, 'Best Online Image', 'A Group describing the webs best images.', 2, 1, 0, 0, 1180293673);

View Replies !

MaxDB, Building A Cluster?
I want my software to be independant of operation system and databases.

That's why I want to use odbc, and don't want to use MFC.

Here I have some questions to ask:

1. On unix (like sun solaris), does there exists any kind of midware like odbc?

2. I search on the internet, and find most of the examples are based on PHP. Is there any c++ examples?

3.Once I chose odbc, does that mean that whatever kind of database I would use later, I don't have to change my source code?

4. now I program on window xp platform. If I use odbc, when impliment my program to a unix platform, do i have to rewrite my code?

View Replies !

Building A Multilingual Portal
Recently I've been trying to write a multilingual portal using PHP and MySQL. Unfortunately there are some design issues. Maybe some of you already figured this out. As for now, I have two solutions:

1) Every language has its own tables, i.e. there should be two tables: 'stuff' and 'things', so the database will store 'stuff_de' 'things_de' and 'stuff_ru' 'things_ru' for german and russian respectively.

2) Every table has a 'lang' column and extracting data from the tables resolves to using "WHERE `lang` = 'de'".

And another thing. If solution 1 is chosen, tables can be stored using:

a) utf-8 or unicode generally
b) collation used for specific language

Solution 2 forces unicode.

The portal will generate couple thousand rows per table max and 6-10 languages will be used. Which solution ('subsolution') should I use? Any suggestions?

View Replies !

Building A Data Dictionary
I have been annotating the fields in the various tables in my database with field level comments (using myPHPAdmin - if that matters) and now would like to learn the commands needed to query the structure of the table so I can import all of these into a single table I can use to generate a printed data dictionary.

I would like to be able to get the field name, type, default value, and comment. I'm sure that there are specific ways to reference these elements in a query but have no clue at this point. myPHPAdmin has ways to export the table structure, but does not include the field comment.

View Replies !

Building Search Engine
In my site users store their information in the database, in multiple tables (tbl_personal_details, tbl address,,,etc.)

I need your help to build Search Engine that searchs and display the information from the database. Just I need links, tutorial, or name of software that help me build the search engine in my site.

View Replies !

Building Stored Procedures?
Does any 1 know of a good webiste/tutorial (for beginners) on building stored procedures......

View Replies !

Building A 1 Page Site?
I have a couple of review site and I'm thinking of building a new one, but along the lines of a 1 page (well, maybe 2 or 3) site. I think the database is pretty basic and the queries dead simple (okay, except for the "I'm thinking about")*, but I'm concerned about 2 things.

1 - site simplicity and fast page loads
2 - some duplicate content

The reviews will have 2 separate text fields.

One will be a description written by me .. unique text.

Another will be a review = customer comments supplied by an affiliate .. duplicate content.

Each text field (description and review) will be up to 10k in size. The database records will also have fields for : name, image link, affiliate link, and a few more .. very brief. Probably a total of 10 fields.

What Im wondering:

1 - what problems should I watch out for, if any, by adding this much text. *I'm thinking about making the first query show up to 10 or 20 items with just maybe the first 30 or 40 words of each text field plus a thumbnail; and then a link in each that would produce a single page with the full text and larger image.

2 - I'm a little concerned that I may get a duplicate content penalty. Will having it in a database help? I'm pretty sure I could put the 'echo' in an iframe and the iframe in a directory and exclude SE bots from that directory with robots.text .. does that make sense?

Finally, there are hundreds of items so I plan on breaking them into categories to keep the menus a reasonable length .. and using javascript to to show an *items* menu when the *category* menu is selected. So should I go ahead and use AJAX to query the database?

View Replies !

Building From The Develepment Tree (windows)
I'm trying to build mysql from the development sources of mysql 4.1.,
retreived using bitkeeper under win2k using cygwin.

I have made "bk -r edit", and now I'm having a problem
running aclocal:

aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library

When I make "automake --version" and "aclocal --version" it prints me
1.4-p5.

Does anyone use cygwin for this, any solutions and advices ?

View Replies !

Building MySQL On SPARC Solaris 9
I have been trying to compile MySQL 4.0.15a on a Sparc Solaris 9 machine
without any success. I do not know if the reason of my failure is the fact
that I want to include SSL support on my MySQL binary. I have successfully
installed (at least that's what I think) OpenSSL on my machine, but have
reached a point where I do not know what else to do. Code:

View Replies !

Building A Filename On The Fly In A Stored Procedure
I have created a stored procedure that performs a number of tasks before exporting the final data.

I have tested it so far with a static filename and the results are as expected.

I now need the exported filename to be tied to the current date.

How do I get the filename in to the SELECT ... INTO OUTFILE Statement?

Here's how I am building the filename:

Concat("c:path", "prefix_", CurDate(), ".cs

View Replies !

Building My First Database Driven Site.
Before I begin, can I just state I have never installed anything on Linux server, so I am very new to this...

Okay at the mo I have and using MYSQL version 3.23.58 on my Linux Sever, incase this is important, heres the details of my server: WEB SERVEUR
Platform : Small - Fedora Core 3
Control panel : Plesk 100
Config : AMEN 2400 - AMD Athlon XP 2400+ Disk: 80 Gb - Memory: 512 Mb

OK, I need to upgrade to the latest MYSQL version. So far, I have downloaded "mysql-standard-5.0.24a-linux-i686.tar" and unpacked the file uner /usr/local

This is where I am stuck, I have no idea what to do next.. I need help for someone never done this before, preferbally a guide like... STEP by STEP, type this,

View Replies !

Building A Friendfeed With Loops, Unions
im having some query issues while trying to create a facebook-like friendfeed.

the first set of queries pulls up all new "friend connections":

- grab id of logged in user
- grab all his friends: get buddylist.buddyId from buddylist where buddylist.uid = 'id of logged in user'
- easy enough!
- see if any of these friends have made any friend connections in the past X days: get buddylist.buddyId from buddylist where buddylist.uid = 'id of buddy' and buddylist.timestamp = 'less than 5 days ago' â€“ AFAIK this can only be done with a php loop and not directly in a query?

next i want to check if any friends have updated a) their profile or b) their company profile. this are two very similar queries which i have UNIONed together. this is in order to be able to display ONE list of data: "mister x updated his profile, mister y updates his company profile, mister z updated his profile, ..." â€“ the results of the queries MUST be mixed, hence the UNION

now id also like to mix in these friend connections. I can not use a UNION because then id have to place my profile updates (the unioned queries) inside that loop ...

View Replies !

Building Programs Using CodeWarrior And Mysql Libs
I'm tring to use CodeWarrior 9 to build a Mach-O target application
on Mac OS X that uses the embedded mysql server library
(libmysqld.a). I'm using the library that comes from
standard Mac OS X binary distribution (the .dmg package).
I can add libmysqld.a to the CodeWarrior project but when
linking, there're lots of undefined symbols referenced from
libmysqld.a. I assume it also needs the equivalent of
-lz and -lm to be added to CodeWarrior (that's what
mysql_config --embedded shows). Does anyone know how
these dependencies should be added? Has anyone done it
successfully before? Or know whether it is even theorectically
possible?

This actually doesn't just apply to embedded library, any
CodeWarrior app that wants to link with the mysql client libs
will also face the same problem.

View Replies !

MySql Hangs When Building/piping From A Dump.
I'm trying to update my local copy of a live database to match a recent dump: Here's what I'm doing, in Windows XP, (from command prompt):

-----
cmd> mysql --user=myuser --password=mypassword
mysql> drop database mydb;
mysql> create database mydb;
mysql> use mydb;
mysql> exit
cmd> mysql --user=myuser --password=mypassword mydb < backup.sql
-----

The query hangs at the 32nd table, which has about 57000 rows with blobs of up to about 9kb. <- I presume this is part of the problem...

I have tried everything I can think of, including reinstalling mySql server and query browser. I have also added the following line into my my.ini file, which is definately the one that is read, I have checked: (in the [mysqld] section)

max_heap_table_size=1073741824

I'm really confused, as up until last week I was able to build my database from a backup with no problems, even through an Ant build with Eclipse.

View Replies !

Building A Statement Problem: Two Tables, 'WHERE' Clause Issue.
Here is the deal: users will post comments on various texts. When a user post a comment, I record the following info in the 'messages' table:

pk (auto increment), textID (the ID of the text being commented), title, message, posterID (the ID of the member posting his/her comment) and finally messaDate.

No problem here.

When I want to display the messages related to a specific text, I get the textID in question using $textID = $_GET['textID']. Then I will need to build my request in order to display the comments recorded about the textID in question. (WHERE messages.textID = $textID). Here, I am also fine.

Here comes the pain for me.

Since I recorded the ID of the poster (not his name) and that I want to display the name of the persons who posted the comments, I will have to get their username using the pk value they got when registering, stored in another table. I hope I am clear. Code:

View Replies !

Building Dynamic Pages For Editing Database Records
I need to develop a way for my client to edit information in a MySQL database. Basically, something very similar to how PHP MyAdmin works only slighly less complicated. There does not need to be the ability to edit the structure of the database or tables or anything like that, simply the information and entries.

I have searched google and yahoo with the following phrases, but have found that most of the results are topics on how to use database editors or where to buy third party software.
------
database administration pages
Building MySQL Admin pages
building web admin page
build a web based database administration console
build PHP my admin pages from scratch
My SQL Admin pages
create web based database administration
Creating administration pages
Creating web admin page from Access in php
------
I've also searched CodingForums.com for threads from others that may have been trying to do the same thing. I didn't really find anything relevent.

Perhaps someone could lead me in the right direction or tell me if I'm not searching correctly. What I'm trying to do has to have been done before, I'm just not having any luck on finding the right information.

I figure that I'm going to end up building this from scratch with PHP, but I thought I'd ask to see where to start or if there are examples out there that I may be able to model after.

View Replies !

For Low End Machine
I am developing a Java Swing application for a low end machine (256ram).

I need a database which will store some tables. Most of the tables will contain only a few hundred records.

There will be a postcode table containing around 1 million records which consists of three columns, postcode, house number and street name.

Could I install mysql server on this type of machine and would that table be too large?

View Replies !

Load On My DS Machine
I've got dedicated server , 30mbp/s line, and solving very strange issue, my hosting told me i burn about 2.8mb per sec., so i get a lot of traffic, i don't use mysql very often, i use mysql only for special cases, no more than 5 requests at same time.
i'm checking top function via telnet console, and i can see sometimes huge loads on server, from 0,8-1 it skips to 20, then 30, 50, 100, somewhere between 20-30 it crashes mysql, and i can't connect , sometimes it went to 150 load, and then it slowly going back to normal.

View Replies !

New Install On W2K Machine
I installed mySQL4 on a W2K machine and I'm able to connect from the c:mysqlin command line, I type mysqlshow and see test as the only database. I was reading the documentation online here and it showed a table mysql. Is that a system table that is required? Did something go wrong in my installation or is this ok?

View Replies !

Speed From Second Machine Bad
I am new to MySQL (mysql-4.1.7-win) with MySql ODBC (MyODBC-3.51.10-x86-win-32bit) and (vb 6 with service pack 5 or Access 2003) to connect via adbc to MySQL.
My seccond machine are terribly slow and would like to know if there are any suggestions.

View Replies !

Two Versions On Same Machine
I had MySQL 4.2 - working fine. I saw version 5 is now stable so I downloaded and installed but did not run it (I think!). Carried on with 4.2.

Then one day MySQLAdmin and Query would not log me on. I checked via the cmd line utility and when I typed in the password the window dissappeared!

I opened MySQLAdmin again and reconfigured the log-on o 3307 (I remember this was default when I installed 5.0). OK, the server must be running. So keep with 5.0 as I managed to restore one of my schemas. I wanted a later version which is only in the 4.1 directories and copied it across BUT 5.0 does not see it. But when I go to stop and restart the 5.0 server in Admin as soon as I go to the server tab to do this it stops automatically! AND will not restart.

View Replies !