Please Help Newbie Upgrading From 4.1.11 To 5.0.x

Newbie
I've written my site using .ASP, Javascript and an MS Access database. I'm now looking to 'upgrade' to MySql to solve any database issues I may have in the future but I haven't a clue about MySql. My questions are;
Does it cost anything?
What do I need?
How do I transfer my tables?
Will my ASP code work on MySql?

---

Newbie
I am a beginner to Mysql however i have worked with Oracle n i had a few questions regarding the syntax,
in oracle we use the number(1) how is it when compared with mysql .I have seen that one can use int but could it be possible also to restrict the nr of digits like int(1).I have tried this out n it does not seem to work.I would also like to know the the diff in varchar n varchar2() if it is the same as in oracle

---

[Newbie] Localhost???
is there any way to connect to the localhost database on another server from a different server?

---

Newbie In MYSQL
I m a newbie in MYSQL.Would somebody pls tell me the following questions-

1. WHich is my original database after creating a Database(e.g. Student) in MySql .I mean in MSAcces DB I can find a .mdb file which is to be used.But in MySql which file to use. (If I create a database named- Student).Would I have to use the whole SQL folder including all files for a single DB.

2. I want to use that DB in MYSQL with JAVA. Which should be the driver String for MySQL.
I am new pls help me.
Edit/Delete Message

---

Is Query Possible? (Newbie)
I have 2 tables used for an online calendar...

first table fields: primary_key , start_date, event_name, event_description
second table fields: primary_key, end_date

Tables fields are shortened and can't be changed.

My second table only contains events that have a end date. I want to create
a query that will take all the fields in. If no end_date exists then set to
NULL. Been playing with it all day. Hoping some advance function exists. I
thought of using a temp table but there must be a better way.

---

Newbie Question.
I am trying to install an accounting package called web-erp on a Linux
system. Early on I need to establish a user with the name of
web-erp@localhost. Unfortunately my copy of MySQL seems to balk at
taking a user name with a hyphen in it,. I have tried enclosing the
user name in single quotes but that generates another kind of error.
Here is the exact statement:

GRANT ALL PRIVILEGES ON *.* TO web-erp@localhost IDENTIFIED BY
'passname' WITH GRANT OPTION;

This statement fails, but the same statement without the hyphen
succeeds.

---

Newbie Question--please Help
I'm setting up mysql for the first time, and running on xp pro. I have
no experience with mysql or databases in general, so I'm quite confused
about some things--I hope someone will be able to help me. I'm reading a
book on php and mysql and in the chapter on post-installation, they're
showing you how to create a password for the root user. They don't
really explain this well, so please bare with me:

1) the username and password for mysql refers not to the windows
username, but something specific to the mysql server correct?

2) the author mentions that when you try to connect to the mysql server
via the mysql monitor, you will have to put in your mysql server
username and password. He says that by default, a user called root is
created for you but not given a password. You should then access the
mysql database (which I assume stores all your user information) with
the root user as follows:

mysql -u root mysql

He then gives a series of commands to enter:

mysql>SET PASSWORD FOR root@localhost=PASSWORD("new password");
mysql>SET PASSWORD FOR root@"%"=PASSWORD("new password");
mysql>FLUSH PRIVILEGES;

the first one works fine and I assigned a password. However, the second
one doesn't work--I get an error message: "error 1133: can't find any
mathing row in the user table" -- I don't understand why this is
happening. It is the same user root right? Incidentally, why am I
entering two passwords for the same user (root)? Is this if I'm running
mysql monitor client app from a remote computer on the internet?

3) do the above commands assign specific usernames and passwords to the
server itself, or to a specific database within? Do all databases
require a separate set of usernames and passwords or is the mysql
database (which this info is being placed in) a special kind of databsee
used just for storing permissions and things like that--does the server
automatically know to check for a database called "mysql" in determining
who has permissions for what?

4) In the line:
mysql -u root mysql
he says that you are accessing the mysql database. How do I know I'm in
the mysql databse if the only thing the prompt just reads "mysql>" which
is just the standard mysql monitor prompt right? I'm able to get into
the mysql monitor without typing any username "mysql" dumps me in
"mysql>" -- but I assume then that I won't be able to access any
specific db info without putting in a username/password, right?

HUH--I probably have a million other questions, but this is all I can
think of right now. I've searched high and low on the Internet and
otherwise for answers but can't seem to get a good explanation of this
stuff. Will someone please explain all about usernames and passwords and
permissions and stuff in mysql--thanks and sorry for the long post?

---

Newbie Question
I want to make a form in mysql. To explain myself further its like when you go to a used car website and it has a text box with a list of different manufacturers and you keep on filling in different text boxes until you get a specific car. Is it possible to do that in mysql??

---

Newbie Question
I am trying to install mysql on XP to use with PHP for a web site that I =
am working on.
I have done everything that the books are telling me but I can't seem to =
get either PHP or Mysql to speak to each other. When I do the tests on =
frontpage, it doesn't seem to do anything.
On the Mysqladmin it tells me that my odbc driver 3,.51 not found is =
that a problem and how do I get the driver?
Also when I go to the database section and right click I don't get the =
create database how do I get this?

---

MySQL Newbie
I am a complete newbie to MySQL. I downloaded the MySQL 4.1.1-alpha
onto my windows 2000 machine and have been trying to figure it out
ever since. I followed the installation directions and managed to do
everything up to running mysql_install_db. cmd prompt wouldn't run the
..sh file, I don't have shell.exe on my machine and maybe that is the
problem, but I couldn't find any documentation about it.
Anyway, I can run the server and manipulate 'test' table, but I can't
log on as a user or administrator, or perform any administrative
tasks. When trying anything I get the "access denied for user
''@'localhost' " 1044 error
I am stuck, because I do not entirely understand the structure of
mysql (what does what exactly) and so I find it hard to try to figure
out the cause for my problem

---

MySQL Newbie
I have started to plan a conversion of my flat file system, to one run by MySQL.
If anyone would please answer these questions, it would clear up a lot of brain fogging around me and I would be very grateful.
1. I will have a table which in one of its fields, lists a series of items (alphabetical names). Where I want to retrieve only those beginning with A, can the MySQL query do this or should I bring in all the values and then process them with php/perl?
2. where I have a MySQL Db hosted on mydomain.com, can I enable other domains to read from it (to power their sites), without compromising security? (All the other sites would be on my own server).

---

Newbie Question
I am at the point in testing where I need to create new tables to keep things 'clean.' I have a users table that has userid in it, auto incrementing as you would expect. Now I want to add another table to deal with some other things. I have seen how to extract data using joins, but now I want to know how I can relate this new table with the users one(and put the userid into the new table)

---

Newbie Can't Upload Dump Pls Help If You Can
This is the error I'm getting. when trying to upload in phpmyadmin.

PHP

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 22, 2006 at 12:48 PM
-- Server version: 4.1.18
-- PHP Version: 4.4.2
--
-- Database: `askdivas_ex`
--
CREATE DATABASE `askdivas_ex` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'askdivas'@'localhost' to database 'askdivas_ex'

---

Connect One Table To Another. Newbie Here....
i´m using phpMyAdmin.

Hi have two tables: cars and constructor how can i make so that when inserting values in my cars table i will have lets say a dropdown list with my constructors?

Like having a products table and one table just for categories and when inserting a new product i would have the categories list to select...

---

Newbie: MySQL Locally?
This may be a dumb question but I am a newbie and well, don't know the answer.

Is there a way to set-up/test a MySQL database locally on my machine?

---

Newbie: Creating Users?
I'm tring to create new users. I've read the docs and still kee recieving the error:

mysql> CREATE USER joeuser IDENTIFIED BY PASSWORD somepass;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER joeuser IDENTIFIED BY PASSWORD somepass' at line 1

How can I check to see if I have access to create users?
I created tables, I don't understand why I can't create users.

13.5.1.1. CREATE USER Syntax
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...

The CREATE USER statement creates new MySQL accounts. To use it, you must have the global CREATE USER privilege or the INSERT privilege for the mysql database. For each account, CREATE USER creates a new record in the mysql.user table that has no privileges. An error occurs if the account already exists.

The account can be given a password with the optional IDENTIFIED BY clause. The user value and the password are given the same way as for the GRANT statement. In particular, to specify the password in plain text, omit the PASSWORD keyword. To specify the password as the hashed value as returned by the PASSWORD() function, include the keyword PASSWORD. See Section 13.5.1.3, “GRANT and REVOKE Syntax�.

---

Extreme Newbie (using A Mac) Needs Basic Help
I bought the book "MySQL Tutorial" and immediately I am confused. I installed MySQL on my Mac, but immediately I am having questions regarding it's use. Am I to type these commands into the Terminal?

---

Newbie: Formating Data In Updates
My POS products table is formatted totally different from that of the Online products table. No problem, I've got FileMaker Pro and it is really good at changing and formating data how I want it. I can output the product records for my website one way, the output the records for Froogle in another format.

The problem is that it takes and extremely long time with 70k+ records. My current scenario is outgrowing itself and I need to come up with a better solution. I need to find a quicker solution, possibly one I can automate down the road.

Any advice for resources? Or examples?

---

Newbie With MySQL CXN Connection Problem
So, I am building a members only application and have the MySQL tables and database already set up and now having trouble connecting my application to the database and could use some help.

On my line 13, I have a mysqli connect pointing to my local host (i just used the server name and then the username and database name. i hid the password in parenthesis here just for protection.

PHP

$cxn=mysqli_connect("h41mysql49.secureserver.net","mankatocustomers","","mankatocustomers")

I also I have modified my php.ini file to include

PHP

extension=php_mysqli.dll

.. because i saw on another form i should add this.

i am using PHP Version 4.3.11 (php info file for me)

i also built a members registration and members login php page you can see by clicking members registration.

--------------------------

so, when you try registering or logging in (i inserted a new member, myself, using phpmyadmin and tried logging into that members registration section) and I kept getting an error like this:

PHP

Fatal error: Call to undefined function: mysqli_connect() in /home/content/p/e/s/peschomd/html/login/Login.php on line 14

Does anyone know whats up? I tried using "localhost" and changing the database name multiple times and looking at my two INC files and nothing changed. I always get the same errors. Anyone can help me would be greatly appreciated to this newbie to php and mysql!

---

Newbie - Cannot Increase Field Size?
First of all my knowledge of mysql databases is about 1%! I am learning by my mistakes thus far but have stumbled onto a bit of a problem. I am trying to fix different things in a pre-made script I was given.

I have a field which is a decription field and so will be filled with quite a large amount of text from the user when submitted.

The problem is its only accepting "257" characters and really this field should be unlimited!

The specs of the field are:

varchar(255)
Null =No

---

Synchronizing Two Mysql Db's...(newbie)
I hope some one can point me in the right direction here...

I need to synchronizing one db on a server (server A) to another db on a seprate server (server B). There both MySQL 4.1.*, is there any way to sync these from the command line (no gui tools)... and what's the easyist MySQL admin tool to help me do this.

---

Ignore Spaces In Query (newbie)
What's the best way to run a query so that spaces in the fields are ignored? For example the following queries....

SELECT * FROM mytable WHERE username = "JohnBobJones"
SELECT * FROM mytable WHERE username = "John Bob Jones"

would find the following entries:

John Bob Jones
JohnBob Jones
JohnBobJones
etc

I'm using Perl so removing spaces from the original query string is no problem. It's the MySQL side of things I'm not sure about.

---

Ignore Spaces In Query (newbie)
What's the best way to run a query so that spaces in the fields are
ignored? For example the following queries....

SELECT * FROM mytable WHERE username = "JohnBobJones"
SELECT * FROM mytable WHERE username = "John Bob Jones"

would find the following entries:

John Bob Jones
JohnBob Jones
JohnBobJones
etc

I'm using Perl so removing spaces from the original query string is no
problem. It's the MySQL side of things I'm not sure about.

---

Newbie Help - Change Datatype Of A Table
--Apple-Mail-5--1016425622
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
format=flowed

how can i change the data type of a table? I'm not sure if that is my
problem. If anyone is interested here is a link what I've been trying to
do:

---

PHPMyAdmin Simple Newbie Question
I'm seeking a tool to administer a remote MySQL database from my Win2k machine.
My only paradigm thusfar is MS SQL Server Enterprise Manager. This is for my
own edification so I want it to be free. My search came up with these:

So I guess that leaves just PHP-Nuke and phpMyAdmin. Any comments you have on
these would be appreciated. I haven't figured out what PHP-Nuke is about yet,
"a news automated system"???

On phpMyAdmin I have one simple question. It looks like phpMyAdmin is supposed
to be installed on the remote machine then you administer the remote database
with phpMyAdmin's web interface. Is this correct?

Is MySQL able to be administered from a remote location like MS SQL Server
Enterprise Manager, with the client software on your local machine?

---

Newbie Question : Database Structure
I am getting up to speed with mysql which is all new to me. The "Teach
yourself in 24 hours" book worked a treat for syntax, and mechanics, but it
hasnt helped me understand how to effectivelyt structure a database.

I have a table for each of the following categories :

Customers Names
Customer Shipping Address
Products

I now want to create a table of orders (from which I can generate all
invoices etc). As each order will consist of (at least) a customer, a
shipping address, any any number of any products.

How best to store the products require for each order as it is open ended?

I had planned on creating an "order Item" which contains an FK for the order
to which the item belongs, an FK for the product that is required, and an
quantity. That table would have one entry for each item ordered, and could
be query'd by OrderNumber to build a list of qty/product for that order

It seems a little clunky, but is that how things like this are done?

Alternatively I wan thinking about a associative array as a field in the
Order table that would contain Product=>Qty pairs.

I think I am more or less there for building simple apps once I figure how
best to do this "undefined number of elements for field" type thing.

---

Newbie Seeks Help Using Backup/restore
I am attempting to bring over a MySQL database from a Windows XP server
to a Sun Solaris server. I seem to be having permission problems, but I
don't even know where to start.

NOTE: I have root access to MySQL, but cripplingly little access to the
server itself. If I knew what access to request, I could probably get
it, but I don't know
I was able to find the .frm files for the old database, as well as to
output a .sql backup file, and to store them on the new server. I tried
to restore them using the following steps:

[Login to MySQL as root user and enter password, then...]

CREATE DATABASE mpf1;
USE mpf1;
RESTORE TABLE submitted_records FROM '/var/apache2/htdocs';

(Note: htdocs is one of the few places I have permission to access.)

And it said "error copying .frm file errno13" and failed to create the
table.

So then I tried it again with FROM
'/var/apache2/htdocs/submitted_records.frm';

same error. Ditto when I went and maxed out the permissions on those
..frm files.

Next, I tried creating a dummy database on the Solaris server and
backing it up to see whether I was having version/migration problems.

BACKUP TABLE dummy_table TO...

Same error.

Anyone have any ideas on where to go with this? I can ask the sysadmin
(at another location) for anything I like, so long as I know why I'm
asking for it

---

Multiple Table Selection Is This Possible - Newbie Question ?
I hope I have explained this well enough for you to understand what I am trying to do.
I table A

Code,CodeType

depending on CodeType it needs info From Different Tables, How can I do this in SELECT
statement?

Select A.Code,A.CodeType,B.NameDesc,C.NameDesc,D.NAmeDesc FROM A
if CodeType=1 then return B.NameDesc FROM B
else if CodeType=2 then return C.NameDesc FROM C
else if CodeType=3 then return D.NameDesc FROM D

---

Newbie Warning: Learning MySQL/Ruby, Priorities?
I've pretty much decided on learning Ruby as my first server side language, and obviously SQL to go with it. Not knowing how the two inter-operate, I'm unclear as to which would be more appropriate to learn first, for someone who is already fairly thorough in Javascript/DOM.

I'm concerned that if I get into one, I'll get stuck because I don't know the other, so I'm trying to decide on how to proceed without becoming dependand on a language i am yet to learn during the process.

So the question would be, MySQL or Ruby first? Or maybe a book/tutorial that nicely fits the two together from the ground up?

---

Some Advice For A Newbie On Big Scale Websites Like Ebay, Facebook, Youtube
I am literally newbie in database design. Just finished kevin yank's build your own database driven website using php and mysql. The book helped me to understand the imporatance of deisgn in a database driven site but I still finding it difficult to figure out the large scale websites like ebay, facebook or youtube. Does anyone know how the database might be designed for these sites. Facebook and youtube are tagbased sites where everything is connected by tags. but how are these tags organized in tables?

---

Query Db From Remote Server Via Shell Script - Newbie, Be Gentle.
I'm looking to connect to a remote mySQL database from a UNIX server, but don't know how.  I downloaded the 'connector' software from mysql.com, but the /bin directory is empty...

Am I missing something?

---

Upgrading To 5 From 3.23
I am considering upgrading to MySQL 5 from version 3.23. My applications have no clients yet but expect them in a few weeks so now is a good time to upgrade.

I use some left joins, outer joins, inner joins but, of course, no sub-selects. I also use as column types; tinytext, text, date, char and varchar.

If I just do a data dump from 3.23 and load it to version 5, should it work?

What do I need to investigate, if anything, before upgrading?

---

Upgrading From 3.23.41 To 4.1
I'm currently running MySQL 3.23.41 and have been
happily doing so for a good while, but now I need to be able to run
subqueries and for this I need to upgrade to 4.1.

Can anyone help me out with a resource or how to on upgrading this the
right way so I don't screw anything up on my server?

---

Upgrading From 3x To 4x
We have a Fedora server located off site. The server is loaded with MySQL 3x and I need to upgrade to 4x. I'm not much of a linux admin (not at all actually). This server has a Plesk control panel so working with that is trivial but I don't know how to update MySQL.

---

Upgrading 4.0.20
I haven't upgraded my MySQL in absolutely years, and I need some of the newer features. What's the easiest way of upgrading without losing any data? Is it to just make a huge SQL dump of all the databases and restoring them like that afterwards, or is there a way I can simply compile a new version, dump it on top of the old one and keep the data files?

---

Upgrading To 5.0.2
I am running SLES 8.0 and I am running mysql 3.23.52. I want to upgrade to 5.0.2. Has anyone done this without going through the intervening levels? I know the recommendation is to go to the next level first.

---

Upgrading From 3.23.41 To 4.1
I'm currently running MySQL 3.23.41 and have been happily doing so for a good while, but now I need to be able to run subqueries and for this I need to upgrade to 4.1.

Can anyone help me out with a resource or how to on upgrading this the right way so I don't screw anything up on my server?

---

Upgrading
I currently have MySQL 4.0.18 on my web sever. I dont really care about the data that is there. do i still have to upgrade to 4.1 before upgrading to the current version?

---

Upgrading From 3.23 To 4.0.16
Few days ago I upgraded my MySQL 3.23.xx (can't remember those two
last, really) to 4.0.16. And then three problems came up (well, more
than two came up, but I solved all the others).

1. problem
I'm pretty sure I don't have any ISAM tables, but I'm not 100% sure.
How do I list types of all tables in ALL databases? SHOW TABLE STATUS
works only for curent database...

2. problem
$ mysqldump -A -uroot -ppassword > /dev/null
mysqldump: Can't get CREATE TABLE for table `forum_01posts` (Can't
open file: 'forum_01posts.MYI'. (errno: 145))

What's that???

3. problem
PHP returns this while trying to connect to MySQL server from machine
WHICH IS NOT LOCALHOST (when trying to connect from localhost,
everything's fine)

($link = mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS) is line
3 in data_connect.php):

Warning: Lost connection to MySQL server during query in
/home/users2/nick/public_html/umzpa/data_connect.php on line 3

Warning: MySQL Connection Failed: Lost connection to MySQL server
during query in /home/users2/nick/public_html/umzpa/data_connect.php
on line 3

I tried to fix this by experimenting with GRANT command, but haven't
succeded. Before upgrading everything was fine. I haven't been
changing mysql.host table. What do I do?

---

Upgrading From 4.1.12 To 5.0.1
can i just install the new version of mysql, stop the
old, point the data directory for the new one to the data directory and
just start up mysql 5? or do i need to take some extra steps int eh
process. also is there any data corruption possible in the process i
described.

---

Upgrading
I'm upgrading a server I have to a 4.0 mysql version. I want to know if I can just move the raw 3.23 databases from one server to the 4.0x server and everything will work fine

---

Upgrading From 3.23.41 To 4.1
I'm currently running MySQL 3.23.41 and have been
happily doing so for a good while, but now I need to be able to run
subqueries and for this I need to upgrade to 4.1.
Can anyone help me out with a resource or how to on upgrading this the
right way so I don't screw anything up on my server?

---

Upgrading
I have an application which installs MySQL 3.23. It's hard-coded. I realize there are newer versions, so I am thinking, what's easiest:

1) install the application with its default 3.23 and then run a script to convert 3.23 to 4.1 or later,
or
2) modify the application to install a newer version of MySQL from the start.

---

Upgrading
i have verion 4.0.25 and i want to upgrade to 4.1.15...
How do i do this i have read the manual with no luck. i seaches google for 30 minutes with no luck at all. is there a strait forward manual on how to do this? BTW im running fedora as my os

---

Upgrading 4.0.25 To 4.1.16 Or 5.0
I've just been given admin rights to a production server running 4.0.25 and need to upgrade this to 4.1.16 or 5.0. The tools I am looking for are in 4.1.16, but would not mind going ot 5.0.The most important issue, being that I just got access to the system, is that I do not screw anything up when I upgrade.My Question; What is the lowest risk upgrade: 4.1.16 or 5.0?What are the exact steps I should take to accomplish the upgrade and not lose any data.

---

Should I Fear Upgrading From 4.0.27 To 4.1?
Are there any reasons that I should not upgrade from 4.0.27 to 4.1? (on a Linux server)

For instance, any known issues regarding existing PHP code getting broken, or character encoding issues, SQL backwards compatibility, and so forth.

I will do a backup first as something can always go wrong, but I have many dozens of sites on the server in question, and if there are any problems caused by the upgrade I might not even find out about them.

Are there any known issues that I should be aware of, or any reasons to decide against upgrading?

---

Upgrading Mysql To 4.1.7
I currently run mysql 3.23.58 on a Linux daffy.perf.redhat.com 2.4.18-11

I wanted to update to mysql 4.1.7 and was wondering how easy it? Is it worth it? What are the benifits. What will it do to my current queries that I have written. Most are simple SELECT statements with some INSERT Statements.

Lastly if I should upgrade, what is the best way to do it.

---

Upgrading To MySQL 4.0
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.

What are the main advantages of upgrading to 4.0? Speed? Features? I can go
through the whole changelog if need be, but I'd prefer to hear what actual
users are reporting as far as benefits and disadvantages.

---

Upgrading MySql
I have MySql installed on Win2k Pro. Recently I downloaded the latest version of MySql, wanted to upgrade the previous alpha version.

So any one here can help me guide to upgrade MySql, step by step, so that I do not loose any of my current MySql settings and databases.

---