MYSQL :: Using MySQL As A Back End

Mysql Back-up
We have an online catalogue running off a mysql database, which we can back
up. When we back it up, it creates a file online called "database.sql"
which, when opened in Notepad starts...
DROP TABLE IF EXISTS store_category;
CREATE TABLE store_category (
category text NOT NULL,....etc

MySQL Back End
I have an Access application which uses an Access database.
I want to replace the Access back end with a MySQL one.
Can I link the new database?
Can I do it in any other way?
I reckon I should be able to, since MySQL has an ODBC driver but just not sure how

Back Up MySQL Database
Plese tell me how do i back up a perticuler mysql database? can i do it from mysql command line? can i manually copy and past? if what folder?

Auto Back Up Of MySQL
I want to Automaticly dackup my MySQL DB, and then upload it to a FTP site so I have a off site back up.

Anyone know of any programs (open source is preffered) that would allow me to do this. I was think batch file my self in scedualed tasks but I am no too sure of what commands to use. This is on a windows 200 server too.

Mysql, Get Back Your Youth

<div align="center">
 
<a
href="http://www.herbal-medical.biz/projectx/hgh.html"><img
src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0">
</a> 
 
 
 
<A HREF="http://www.herbal-medical.biz/projectx/hgh.html">Click Here If Image Doesnt Load</A>
 
 
</div>
<CENTER>WdXfuRttYR, yJJZQwQUqY
 
 
<A HREF="http://www.herbal-medical.biz/optout.html">No More Emails Please</A> </CENTER>

Back Up MySQL In A PHP File
I need a script that will find all tables and all rows and all data it makes a file called back.sql with all the info in it. How do you do that. My Web host dont got PHpmyadmin or nothing.

My MySQL Back-end Works Very Slow
I have installed my MySQL Server in a Window XP platform running in a Pentium4 machine. When I access the database on the machine, it is working in a normal speed. But when I access the database from a client machine (still running in windows platform), it runs very slow.

Slow Performance After Falling Back To MySQL 3
Yesterday I have upgraded my linux box with a pair of Xeon 1G CPU and
reinstalled everything (it was a sinle Xeon 700). The default RH9
installation comes with MySQL 3.23.54. After the reinstallation I
found the machine was not as responsive as before. (It's not very
slow, but some lagging is noticed)

I was running Mysql-max 4.0.11 and the performance was ok, except the
slowness during the peak hours, which was regarded as normal. I would
like to know the differences between Mysql 3 and 4. Is the new version
making a significant jump in performance?

I also noticed the system eats up memory faster than before. With the
old setting the system never used up 60% of physical memory, even at
extremely high loading (30+). Now it easily used up 70% of memory.

The server is running Mysql only. It's equipped with 2 Xeon 1G and 2G
of memory. The kernel version is 2.4.20-8smp #1 SMP. Also attached the
my.cnf for a clearer picture: Code:

MySQL Takes FOREVER To Start Back Up
Need some help here. I am running MySQL 4.1 on a windows 2003 server. We've had the server for about a year and right now the data file for the database is up to 345mb. Its growing week by week.

Lately if I had to restart my server once windows comes back up it takes 20min for MySQL to start back up.

Easiest Way To Back Up MYSQL Database To Move Over To Another Computer
I've been working through Sitepoint's Build Your Own Database Driven Website and I've decided to change which of my computer's I use as my test server. I installed Apache, PHP and MySql on the new "server" and tried to copy over my database folder, but I can't seem to get it to work in the MySql client. I looked through the documentation for information about maybe making a backup and then restoring it to the new server, but I was a little overwhelmed. Anyone have an easy suggestion to accomplish this. I'm sure it's much easier than I'm making it.

Back Up
I am using a linux hosting and hosting 5 websites on it.
the main prob solutions i need is that i need to change my web server but don't know how to take backup of database and all that.

So can any bosy tell me how to take a database backup so that i can make my files used on other server and how to use the backup on the new server.

Back Up
I am running php, mysql on window xp.

when user insert something to the database (mysql). where does the information stored?

I want to be able to make a back up copy of my data just incase I want to move from one pc to another...

Schedule A Back Up
I am attempting to schedule an automatic back up through the MySQL Administrator (version 1.2.2) and I cannot get it to run. I can save the project, set my conditions, but it never actually runs. If I choose to run the back up now, it works. I have tried setting this up both remote and on the actual server. I do not receive any error messages, and do not know where to check to see if it even attempts to start.

Looking Back Query
I have two tables, WIDGETS and VERSIONS. The WIDGETS table has descriptive information about the widgets while the VERSIONS table contains IDs relating to different iterations of those widgets over the years. The idea is that from any widget in the database you can look forward and backward to see different versions of the widget through the years. Here are the tables:

CODEWIDGETS
widget_id
name
description
year

VERSIONS
v_id
new_id
old_id

Back Up Database
I have MySQL 5.0.22 installed on Windows XP (32 bit) - on few machines.

1. To make a backup - do I have to run mysqldump or can I just copy C:Program FilesMySQLMySQL Server 5.0data somewhere? If so, how can I restore the database having data folder?

2. If I need to transfer the database from one machine to another (the same OS and MySQL) - can I use binary files from data folder or mysqldump is the only option?

How To Get ID Back After I Insert A New Row?
I have 2 tables , article and tags.

article has 3 fields, id, title , content
tags has 3, tagid, tagname, aritcle_id

insert into article (title, content) values ('abc','abcd');
I need article ID back to insert tags into tags table.

my solution is add new select statement before insert into article (title, content) values ('abc','abcd');

I can select max(id) from article, then use this id number to insert article and tags tables.

not sure if this is only way to do it or there is a better solution. also, if there are alot users use my web application simultaneously, i am worry that user A issue select statment to get max ID, before he uses it. User B also select max id, then they probably get same ID number.

What Back-end Database
I'm starting to learn Visual Basic. My aim is to develop a small
downloadable application that can store and display contacts. It has to
be small (say 2 mb footprint?).

Q - First, will Visual Basic give me this small footprint ?

Q - What back-end database is advisable (I'm familiar with MySQL),
considering that the tables will be small ?

Basic goal is that the application should be universally downloadable,
installable (on all windows) and must fit in a small footprint.

Q - Or let me ask very broadly - what technologies would *you* use if
you had to develop such an application ?

DB Back-up SSH || Forum
when i backed up dB using SSH db is for exmaple 50 MB

Code:

mysqldump -u zodehala -p123 db > backup/vb.sql

but if i use vBulletin its interface to back up db is for example 80 MB
What is the difference between them ?
what is technical explain ?

Back To MySQL4
I have built a website using PHP5 and MySQL5 only to find that I cannot find a host that uses MySQL 5 yet…
I have now changed the site to access the database via PDO.
Problem is, PDO does not currently work with MySQL5 (correct? If anyone could tell me how to get PDO to work with MySQL5 this would be brilliant!)
I therefore need to load MySQL4 onto a machine that is already running MySQL5.
Do I need to uninstall MySQL5 first?

Need Help With Putting In Database Back Up
i just installed xampp and i have phpmyadmin to handle my mysql databses. i dont know how to put in my database that i had on my web server that i got a backup of though. the backup was from cpanel , does anyone know how to do this? thanks

Roll Back Using Bin Log On Myisam ?
Is it possible to roll back changes on MyISAM tables using the bin log? Some tables were dropped, truncated, or delete from'd (not sure yet), and need to know if there's anything we can do without an active backup.

Database Erased No Back Up
I have recently erased a database and I have no backup and I am running coroners toolkit. Is there any more software available to recover specifically MySQL?

Getting Back Set Order From The IN Param
My query is as follows:

SELECT STRINGTEXT, TOKENID
FROM WEBSTRINGS
WHERE TOKENID IN (6,20,234,19,32,4,800,177)

All I want is my resultset to come back in the order that I have defined in
the IN clause, but unfortunately SQL is trying to be too helpful and sorts
the numbers in the IN clause so that the resultset comes back with a TOKENID
order of 4,6,19,20,32,177,234,800.

I don't want this bloody order I want 6,20,234,19,32,4,800,177!!

Roll Back Problems
I am rolling back a transaction that (up to the rollback command) has
inserted into two tables, both of which are type InnoDB. I am getting the
warning:

"Warning: Some non-transactional changed tables couldn't be rolled back"

I check the database and it seems to have rolled back all the changes I
expected it to make, so why is this error occurring. I am using MySQL
4.0.18; is it a a minor known bug? Is there "hidden" tables that it is
updating that might be causing this warning?

Getting Unicode Back From Database
I am converting data from widestring to utf8 strings to try to get it onto MySQL, using Delphi's UTF8Encode and UTF8Decode functions. But it's coming back as gibberish.

I copied the word ÐºÐ¾Ð´Ð¾Ð¼ from the russian page of the zeoslib site. Looking at the numeric values of the characters of that I got
043A, 043E, 0434, 043E, 043C, which corresponds with the Russian character chart on unicode.org. I converted that to utf8, which gave me:
D0,BA,D0,BE,D0,B4,D0,BE,D0,BC, which is a simple conversion.
That was then saved to the database. So far so good.

But when I read that back, it came back as
C3,3F,C2,BA,C3,3F,C2,BE,C3,3F,C2,B4,C3,3F,C2,BE,C3,3F,C2,BC, i.e. four groups of four bytes, where the last of each group correspond with the 2nd char of the utf8, but the other 3 are not useful. (3f = '?').

And when I pass that to UTF8Decode I get a blank widestring returned.

So, I can't do much with it as is. Does anyone know what's going on? And more importantly, what is the right way to get unicode into and out of a database? I'm using MySQL 4.1.3b for Windows, with the latest zeos components.

My Tables Back Into A Database
how I can get the backup ( just a file copy of the
directory with .frm, .MYI and .MYD files) back into a newly created
database.
I am failry new to MySQL.
Due to a crash of my Windows 2003 server I was in a hurry creating a very
quick backup so I didn't tokk the time to find out what a correct backup
mechanisme shoul be.
Now I have a new server and installed the latest MYSQL (I think I had an
earlier version before)
I just copied the files into the "mysql datafiles" folder. It doesn't pick
them up automaticaly.
Can anybody tell me how to get them back in.

Get Back Image File
I am sort of new to this and I have been searching for a few days now and can not find anything on this at all.

What I need to be able to do is take a image stored in Mysql and save in back to the server as a file and I can not find out how. I know its got ot be simple and I am not the only one that needs to do this ... so can someone clue me in here.

Read Back Up File
I got this error.

shell> mysql -e "source /var/lib/mysql/test.sql" backuptest
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'backuptest'

Reset Fields Back To 0
I've been running through some test where I have fields for a Win, Loss, and Tie. in a table.

Now that testing is almost complete. Is there a way to reset all rows back to a 0 value?

How To Put HTML Input Into Database With PHP And Back
Could someone please post a brief example of how to take input entered into HTML forms and put them into a MySQL database with PHP? And could I also get an example of the reverse, that is: taking data from a MySQL database and showing it in an HTML page with PHP. I would very much appreciate this. Simple examples will do, I don't need anything that is really functional, just a basic example.

Moving Back From Continue Command
How do I move back wards from the continue command prompt. My problem is if I am inputting large amounts of code and I mess up I will catch the error next line. There has to be some way to go up to that line... Here is an example:

mysql>CREATE TABLE clients (
->client id SMALLINT(3) USIGNED NOT NULL AUTO_INCREMENT,
->

I made the error of not making it client_id so how do I get back to fix it.

How To Dump The Database And Read It Back In?
Our database just slowed down radically. Certain queries drive CPU
utilization through the roof. This happened once before, and the technican
simply dumped the data to disk and then played it back in. This seemed to
correct database corruption. After than, the database went back to normal
performance. Does anyone know how to do this?

Back Up And Auto Increment Field
I have written a backup routine in PERL which works ok except for a problem if the backup is restored.

My tables cross reference on an auto - increment field but when I create a new set of tables, the auto increment fields are reset too, therefore losing the relationships.
I have written a work round where the 'number' fields are copied to a non auto field and then copied back to the auto field after restore.

How To Put Old Database Files Back Into A New Install
I've inherrited a product that is trying to use mysql. Noone seems to recall the root password. I tried all the published methods I could find (--skip-grant-tables and the other one where we set the password in the init files) and none of them work.

So, I went to a second approach. I deleted my installation of mysql, reinstalled and reset the root password. Now, I can't figure out how to get the old data into the new installation. Copying the data files into the data directory doesnt work. I assume I need to do some sort of import? I need to import the data and schemas alike.

Convert Hex String Back To Binary
Using MySQL 4.017 on Win2k sp3:

using MySQL built-ins: how can I convert a
value stored as a hexadecimal string back to
a binary string while logged into the shell?
[color=blue]
>set @t1=616263;
>select 0x616263;[/color]

how can I turn @t1 back into 0x616263? What is
the syntax? I tried
select concat('0x', @t1);
this returns an unevaluated literal!

Convert Hex String Back To Binary
using MySQL built-ins: how can I convert a
value stored as a hexadecimal string back to
a binary string while logged into the shell?
[color=blue]
>set @t1=616263;
>select 0x616263;[/color]

how can I turn @t1 back into 0x616263? What is
the syntax? I tried
select concat('0x', @t1);
this returns an unevaluated literal!

Auto_increment, Bring Back The Record With The Old Id (auo_increment Value)?
For example, the ID is auto_increment value.

ID Name
1 Bill
2 Geo
3 Rice
4 Sam
5 Hu
6 - deleted
7 - deleted

The next time insert, the ID will be 8.

So far no problem.

My questions are

1) If the record, 2 Geo, is deleted by mistake.

And I want to input, 2 Geo, back.

Could I just add the record, 2 Geo, back. and manually set the auto_increment value ID to be 2?

I did it, it seems fine. This will not bring any problems in the future?

2)

Instead of the auto_increment value will be 8 when I insert a new value, if I manually set the ID value to be 11, that will be fine, right? the next new insert after this, it will be 12, auto_increment will always be the value 1 bigger than the max id value, right?

Return Back All The Privleadges To The Root User
I accidently remove all the privleadges of the root user of MySQL on a web hosting server.I need your help that how i can return back all the privleadges to the root user.

Can I Start AUTO_INCREMENT Back To Fill In Unused Numbers?
I've got an InnoDB table of people who are identified by a PersonID (primary key), and it's passing 50,000 and growing quickly. My users have deleted thousands of records in the past, so there are thousands of unused PersonID number's that can be used that are less than 50,000, where it is now.

Can I set the AUTO_INCREMENT back to, say, 1 and have it fill in the empty numbers? Is that even possible? Will it just look for the next available, unique number and use it?

Updated Table Fields Rolling Back After Update
I'm having to correct some scripts written by a collegue who is presently not around. I had to update 2 fields with over 13000 rows. The update do work well but the problem is that somehow, the initial values in the fields do roll back in again - kind of auto updating to the former values itself. Any ideas what could be wrong? Any way round it?

Memory Size Exhausted Error - Too Much Info Back From Query - What To Do?
Using PHP and MYSQL I changed one of my MySQL search queries to allow a
situation where the user gets much more information returned then
previously

However, it has now given me the error message:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to

allocate 42 bytes) in /usr/share/pear/DB/mysql.php on line 290

OK I understand what this means (I assume) that the program is trying
to
allocate more memory to return my query result but it wont let it.

However, I need this query to return this info, so what can I do?

Rolling Back A DB From Version 5 To Version 4
I've got a local MySQL DB with my MediaWiki data that was created in version 5.0.17, but I recently discovered that my webhost is running version 4.0.27, and when I tried to import the database as-is, I received an error.

I'm looking for suggestions as to how I could roll my database back to the older version of MySQL, in case my webhost decides not to let me upgrade. I've considered using an intermediary, such as converting to MDB or CSV, but so far I haven't had much luck with finding a tool to do so without spending a pile o' cash.

ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem.

I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:

Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root,
then type "mysql", I am able to connect to the server and run my
queries.

If I exit out of su so that I am my own id (baisley) and type "mysql",
I get this error: Can't connect to local MySQL server through socket
'/home/data/mysql/mysql.sock' (13)

Any idea why? mysql.sock has full permissions (read/write/execute), so
it should be accessable by user baisley. If I am baisley and I run
"mysql -u mysql" (as mysql is the user that the RPM set up), it will
connect.

What I would like to be able to do is run this without having to be
user mysql all the time. How do I go about setting that up, or is it
better to run all my queries/make tables as 1 user?

ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment:
ASP.NET ver 2
MySQL 5.0
FP Extensions 2003

Progression:
Developed Website Outline
Developed Database in Access2003
Migrated AccessDB to MySQL @ Hosting Service using Migration Tool.
Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there.

PROBLEM: (The heart of the matter)
Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get:

"Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.

ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away"

Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.

Warning: Mysql() [function.mysql]: Access Denied For User 'apache'@'localhost' (using
my script is not connecting to my database, i get this error

Warning: mysql() [function.mysql]: Access denied for user 'apache'@'localhost' (using password: NO)

Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean

Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6
Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6

Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6
here4
Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13

I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help: