MYSQL :: How To Reset Yahoo Small Business MySQL Database

How To Reset MySQL Database
I am a new user of "Yahoo Small Business" web hosting service and I changed
a lot of settings in my "MySQL Database" using "phpMyAdmin" utility during my
learning period. Now, I want to reset my Yahoo Small Business MySQL Database
to default settings or to reinstall it (I want it to be the same as it was newly
activated). As you can see, I can not control the server, so I have to do this
only by scripts or commands.

Please Note: I tried to repair my database with Yahoo's "Database Setup" page
and the message "Database scheduled for repair" appeared for a few days but
nothing happened. And, I can not login to my database using phpMyAdmin utility.

View Replies !

One Big Database Or A Lot Of Small Ones?
My boss is implementing a system where a lot of different sites will be using the same exact database structure. He has it in his head that things would be simpler with one database shared by hundreds, possibly thousands of sites. I feel like each site deserves it's own database, even if it involves more maintainence.

View Replies !

Backup A Small Database.
I'm looking to backup a small mysql database. The problem is mysqldump does not exist on the server I'm trying to export the database from.

Does a php script exist which I could use to do essentially the same thing as mysqldump?

View Replies !

Accessing MySql On Yahoo
I have never used MySql before.I program in C# and Visual FoxPro against
MS SQL on a corporate network.
I have a Yahoo web page, and I'm going to use their MySQL DB.
I want to run queries, Inserts, Updates and Deletes.
I have no idea how to connect to MySql on Yahoo from a client like
C# or VFP.

View Replies !

A Huge Database Or A Lot Of Small Databases
I have a question regarding database performance.

Which of these two designs would be better:

-Having one huge database with 50 tables or so (each table having millions of rows)

or

-Having a lot of databases with the same amount of tables, but each table would have only thousands of rows

*The mysqlserver is running on a P4 3.0 ghz with 1 gb in ram, but I may upgrade my server soon.

*Privileges to create databases is not a problem since I own the server

View Replies !

Small Database, High Load
I have a very heavy mysql database used website. Data is constantly being updated and at peak there is well over 1,000 people online, after it hits the 1,000 mark, the website starts to lag pretty bad.

My database is only small at around 90mb. We have a web server for the files, and a database server for the database. The load on the web server is fine. But the database server is pretty high.

Would replication reduce lag and load? if i was too add a second database server?

View Replies !

Inserting Small Image Directly Into Database
How do you insert an image into a table directly using something like data studio?
I have tried googling it and it seems all the examples are using a language to do it for you. The images are between 2-4k and the table is just an int column followed by a blob column. I just thought the statement would go like

INSERT INTO sometable VALUES (1,'image.jpg');

The web suggests uploading and downloading in PHP (which im using) but im building the data first using data studio then just displaying the table information using PHP.

Before i go into displaying the information on the page i just wanted to make sure the insert query is correct.

View Replies !

Small SQL & Php Webpage Field Database Task
In a webpage, imagine a little section where the user fills in his/her contact details to register. Among this section is a field called "Country". The task is to make this field automatically generate the persons current country of residence. I am told, that the IP ranges and the country to which they belong is in a CSV .xls file. I am also told that the best way to do this is to:

1) Insert the CSV into database table (MySQL).
2) Use php to get that country name onto the website field.

View Replies !

Connecting To Yahoo Webhosting MySQL Sites
1. I've signed up for yahoo webhosting because they had MySQL
2. Installed their phpadmin tools and setup the admin username / password for my db's, create one db and table
3. I downloaded and installd the MySQL GUI tools
4. Pointed MySQL admin to my domain name with un/pw default port 3306

And all I get is "Can't connect to MySQL server on domain name (10060)

View Replies !

Reset Database
I have built a database with a Primary Key / Auto Increment.

I have been doing loads of testing with adding and deleting records.

Now I need to delete all of the test records, and put the database on a live website.

Is there anyway to reset the Primary Key back to 1. Now when I have deleted all the records, the Primary Key uses the next number from when the records existed.

View Replies !

Reset A Value In A Database Weekly/monthly
im making a site [php/mysql] for a guy which allows a user to upload 3 pictures a day, so i having a parameter in the database associated with each user [userUploadsRemaining] then setting this to 3, then decrementing it each time they upload.

The problem is i want to reset this value every week to 3 for all users. Whats the best way to achieve this ?

View Replies !

Calculating Business Days
I need to calculate the number of business days between a pair of arbitrary dates.Some scrounging around online delivered me this query,which basically does the trick:
Quote:SELECT
d1,
d2,
@dow1 := DAYOFWEEK(d1) AS dow1,
@dow2 := DAYOFWEEK(d2) AS dow2,
@days := DATEDIFF(d2,d1) AS Days,
@wknddays := 2 * FLOOR( @days / 7 ) +
if( @dow1 = 1 AND @dow2 > 1, 1,
if( @dow1 = 7 AND @dow2 = 1, 1,
if( @dow1 > 1 AND @dow1 > @dow2, 2,
if( @dow1 < 7 AND @dow2 = 7, 1, 0 )
)
)
) AS WkndDays,
@days - @wkndDays AS BizDays
FROM dates
ORDER BY d1,d2;

View Replies !

Jdbc Over SSL, SAP Business Connector 4.6
I have set up a connection between SAP Business Connector 4.6 and MYSQL. I'm currently using jdbc driver com.mysql.jdbc.Driver (mysql-connector-java-3.0.16-ga-bin.jar).

Using DB URL jdbc:mysql://<ip>/<database> the connection is working fine.

So far so good.

Now my problem:
I need to set up a SSL connection but in MySQL Connector/J Documentation is stated:
'For SSL Support to work, you must have the following:

A JDK that includes JSSE (Java Secure Sockets Extension), like JDK-1.4.1 or newer. SSL does not currently work with a JDK that you can add JSSE to, like JDK-1.2.x or JDK-1.3.x due to the following JSSE bug:

http://developer.java.sun.com/developer/bugParade/bugs/4273544.html'

My SAP business connector is running under jdk 1.3.0

How do I get SSL running?

View Replies !

Selecting Results From This Business Week
I have a table which has the column 'date_added'. I need a query which returns all of the results which were added in the current week. By this I dont mean today minus 7 days, I mean monday 00.00am to sunday 11.59pm.

Is there a way of doing this? I've looked into WEEK() and YEARWEEK() but cant think of a way to do this using PHP.

Heres what I've got (probably awfully wrong..

PHP

mysql_query("SELECT * FROM table WHERE date_added BETWEEN WEEK(now(), 0) AND WEEK(??)");

View Replies !

MySQL Upload Small Files
I'm uploading small files (>10K) and mysql is deleting it. The one field is a blob field and everytime i test upload a file thru phpMyAdmin within 2 seconds mysql deletes the row. Theres nothing in mysqld.log, there another log i should be checking out?

View Replies !

LAMP Developers On Yahoo
For those interested,

A yahoo group devoted to LAMP ( Linux-Apache-MySQL-PHP ) develoment;

View Replies !

Yahoo's GeoCities Pro Hosting
I am using Yahoo's GeoCities Pro Hosting and when I get into "MyPHPadmin" to view my databases I get the following message.

Warning: Your privilege table structure seem to be older than this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!

How can I get to the script?? Can't find it.

View Replies !

Connecting Yahoo Messenger?
is there any way to connecting mysql & yahoo messenger?

i want to make application that automatic answering using yahoo messenger which retrieving data from MySQL database...

View Replies !

YROOT Default Password On Yahoo Web Hosting
Can any one tell me the mysql database default password of "yroot" user on yahoo web hosting?

2- How can I delete user from mysql database on yahoo web hosting?

View Replies !

Cause Of MySQL Auto_increment Reset?
We've got a site which was moved off of our servers and now is having problems on a monthly basis and the site owners are asking for our help. :P

The server they moved the site to is a virtualized Linux server on an MS Windows server, using something like VMWare or similar to run the Linux environment in. The server is running with MySQL 4.1.20 on it. Originally when the database was imported the auto increment data on a critical table somehow didn't get set so since only a portion of their site is updated on a semi-monthly basis via MySQL, no one noticed for a couple of months that occassionally the wrong data popped up. The current month's data index was deleted each month and recreated with brand new data, but the index stayed the same. After the increment was reintroduced to the table, it somehow got reset to something far below the next auto_increment value in the table.

I've been messing around under the mysql CLI and phpMyAdmin to atmysqlt to even set an auto_increment value below the current one and can't do it (even though it tells me success). I tried manually setting the auto increment, deleting, setting, then re-adding the auto_increment index, as well as other things but with data in the table, it never changes to anything other than what the auto_increment should be. Removing the data, changing the auto_increment index, then re-inserting the data is also a no-go in terms of messing up the auto_increment to be less than the indexed data values.

I've never seen the auto_increment itself break in MySQL before although I've had to fix corrupt tables before. This only seems to happen after the virtual Linux server is restarted. According to another consultant this client uses:

> Auto Increment is a MySQL table feature that picks the
> next available index number to use. Recycling of unused index numbers is
> a feature that has been removed from newer major releases.

Having used MySQL since 3.x I've never heard of this "recycling" before. What can break the auto_increment like this? (corruption?)

View Replies !

RESET Password Of Mysql On Mac OS Server
Can somebody help me reset the password on mysql ? I need the commands to force the change cause I can't login to mysql. I am using mac os server 10.3.9 and I have messed up the mysql password I have full access priviliges on the mac server.

View Replies !

MySQL Query Cache: Should I Cache Small, Simple Queries Or Only Complex Ones?
Query cache works great for long, complex queries, but should I also be caching the simplest of select queries.

For example let's say I had a table with 100 records and I needed to select something using a unique key:

SELECT name FROM products WHERE id = 3
Is caching the above pointless, especially in terms of wasted cache memory, considering how basic it is?

View Replies !

Handler_read_rnd_next = 13k On SMALL Db
I have two very small DBs.

One for a little number game, which only 6 people hit 1-3 times a day. The other is for a prototype of a game I'm working on, and there are no more than 3 users on this.

Using phpmyadmin, I check the page with runtime info and I see

Handler_read_rnd_next 13 k

If I reload this page a couple times, it goes up to 14k.

Most of the queries I use look like

Code:

SELECT c.color, b.percent
FROM tbl_creatures a, tbl_creatures_colors b, tbl_colors c
WHERE a.creature_id =1
AND a.creature_id = b.creature_id
AND b.color_id = c.color_id

And the EXPLAIN SQL for these comes up with

Code:

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Using index
1 SIMPLE b ref PRIMARY,color_idPRIMARY 4 const 2
1 SIMPLE c eq_ref PRIMARY PRIMARY 4 hq_proto_creatures.b.color_id 1

To me, this all looks fine. I can't tell if all the Handler_read_rnd_next is due to the phpmyadmin status checks or not.

View Replies !

Small Databases
I am wondering if having a database for the client back office, a database for the static website and a database for website stats would be a good idea.

The client database would hold credit card info, user info, reg info, project info, client messages and more.
The website database would carry all the content for the pages of the public website like about us, contact, home page, news and such.
The website stats database would keep track of user agents, new hits, returning hits, keyword searches made on the client websites and all that jazz.
Should I make this all ONE giant database or three smaller database?

View Replies !

One Big Table Or Many Small Ones?
I am designing an interactive website consisting of a few pages and I want to track individual user progress. I was wondering if it would be better to create one big table for all values on all pages (Which may have a lot of columns, easily hundred or more), or created a separate table for each page (so I could have some 10 tables with 10 columns or more). Or does it not matter?

View Replies !

Big Select Vs Small Ones
I have an array of 10 IDs.
I need to query the db for values associated with these 10 IDs.

In a lot of places, I have seen people using a php foreach like this

foreach (ids in array)
{
query = SELECT values FROM tables WHERE id = [id 1 in array]
do query
store values
}

we could build one big select statement like this:

query = SELECT values FROM tables WHERE id = [id 1 in array] OR [id 2 in array] OR [id 3 in array].... until we have ids.

View Replies !

Small Query Optimization
I need this query optimized using indexes. So I was wondering how I could optimize it to work with an index for speed.The query is:

Quote: select ided from products where dates <= 2006-11-11 or cost=0.00 or url not like 'http://%' or imgurl not like 'http%'

I tried making an index on (dates,cost,url,imgurl) but it doesn't seem to use the index when I do the explain part. I find that even when I miss of the like parts of the query it still is not using the index. It seems to not use the index because of the "or" that is used in the query instead of the "and". Could this be the reason and how could I over come this so that it will use the index.

View Replies !

Small Favor Gone Wrong
I have a VPS account and I am trying to move my sister's professional organizations site onto my server more or less as a favor (getting paid a little - but not really worth my time). It is being hosted by a professional hosting company that supplied me with ftp access to download the site for the move.

I am running into a problem because I don't know how to set-up/use mySQL through UNIX. Previously I have used the Plesk interface provided with my VPS account. Plesk (or at least my hosting services configuration of it) won't allow me to create the user I need in order to import the database because the user ID is contained within the user PW. (this is the database coming from the vendor).

The original host has been unhelpful at best so I thought before I go to them and ask for assistance (that I am pretty sure I won't get anyway) that I would post here to find out if there is any easy way through this roadblock or if any the unix commands are simple enough, how I would proceed that way.

View Replies !

Small Binary Data
Can anybody tell me what way is best to save a small binary data (16 Byte) in MySQL?

View Replies !

One Large Table Or Many Small Tables?
I'm trying to decide whether to use one large table or many small tables.
I need to gather information from various devices (about 500). Each device
has its own Id and some data.

Should I use only one table with an indexed column for the ID and another
column for the data, or should I use 500 tables each with only one column
for the data?

View Replies !

One Big Query Vs Lots Of Small Queries
I am in the process of migrating a MySQL database from one schema to another and am writing a script to extract the info from one table to be inserted into multiple tables on new new db.
My question is this, is it better for me to make one giant query (about 1 million records returned) on the source table, manipulate the data, then enter in the data by cycling through the results, or would it be better to split up the query on the source table into lots of smaller queries with a short pause in between?

View Replies !

Structure Of Small Social Network
I need to setup a social network type mysql database, but not as intense as friendster, thefacebook, myspace, etc.

i have a structure set up but it think it's weak and extremely limited:

Code:

+---------+-----------+
| user_id | friend_id |
+---------+-----------+
| 5 | 4 |
| 1 | 7 |
+---------+-----------+

i fear it's going to be a lot of redundant IDs in a column, which i think could be a problem when retreiving friends:

Code:

+---------+-----------+
| user_id | friend_id |
+---------+-----------+
| 5 | 4 |
| 1 | 7 |
| 1 | 9 |
| 7 | 9 |
+---------+-----------+

i want to do a "bob is friends with john" and a "jackie knows sally through richard" (aka friend of a friend). that's it and nothing more. how do i structure mySQL database to be able to this?

View Replies !

One Huge Table As Appose To Many Small Ones
i have a very large XML DB (60gb+ and growing on a daily basis) which holds complete life cycles of stock option , i used to hold it all in folders with each folder named like the option paperId so it seemed logical to me to hold it now in diffrent tables for each paper even tough the are all the same exact table , now i'm having some problems with hibernate (one of the biggest reasons i left XML) and so many tables , is it more effiecent to keeeping data like that ?

ofcours i will have to change the PK from datetime to paperId+DateTime if i decide to change to one big table ... how can i calculate diffrence in retrieving data ?

View Replies !

Several Small Calls Vs One Large Call
I am working on a php interface to a mySQL db which will pull lots of rows from the database. Assuming I am selecting a hundred rows by their auto_incremented ID's, is it better to do this with a loop of 100 "SELECT ... WHERE id=" calls, or to do it with one single "SELECT ... WHERE id IN(...)" call, with IN() holding a list of the hundred items.

View Replies !

One Large Table Vs. Many Small Tables
I'm working on a design using PHP & MySQL and I'd like to get some opinions on this.

My design has several tables that will be referenced but I'm wondering if those tables should be broken down even more and referenced more dynamically. The reason that I wonder about this is for long term goals. I hope that eventually there will be two or three thousand records that will be used on a regular basis. These records will need to be separated into groups, but I'm not sure if I should use a field in the database table or create a new table for each group.

If a few hundred records could be in each group, do you think it's better to use one large table with a field for the group ID, or a new table for each group?

View Replies !

Help With A Small Query Optimization Using An Index. THANKS!
I need this query optimized using indexes. So I was wondering how I could optimize it to work with an index for speed.

The query is:

Quote:

select ided from products where dates <= 2006-11-11 or cost=0.00 or url not like 'http://%' or imgurl not like 'http%'

I tried making an index on (dates,cost,url,imgurl) but it doesn't seem to use the index when I do the explain part. I find that even when I miss of the like parts of the query it still is not using the index. It seems to not use the index because of the "or" that is used in the query instead of the "and". Could this be the reason and how could I over come this so that it will use the index.

View Replies !

Large .sql File (break Down To Small Parts)
i have an oscommerce installation that generates a 200mb sql backup file. i want to try and rebuild the installation on my local pc (localhost) to emulate and play with, unfortunately the 200mb file is difficult to handle. phpymadmin seems to crash.

i have console access on the host however.

is there a way i can break down the sql file into smaller increments for easier uploading?

View Replies !

Reset Primary
I have built a database with a Primary Key / Auto Increment.
I have been doing loads of testing with adding and deleting records.
Now I need to delete all of the test records, and put the database on a live
website.Is there anyway to reset the Primary Key back to 1. Now when I have deleted
all the records, the Primary Key uses the next number from when the records
existed.

View Replies !

Reset Autoincremet
How can I reset a AUTOINCREMENT column so it starts from 1 to n.

View Replies !

How To Reset Next Autoindex
Need a hand figuring out how to reset the next autoindex value in MySQL v 4.1.21.

I have a sessions table which gets a lot of inserts. The record id field is an autoincrement integer unsigned (nothing unusual there). Simply "DELETE from sessions WHERE expiry < CURRENT_TIME" does empty the table if all sessions have expired, but of course the auto index value is not reset. As a result, the value of the id is getting quite large.

Now, I know I can simply "TRUNCATE sessions", however, to do this safely I need to single thread access to the sessions table, check that all sessions have expired, then perform the truncation. However, TRUNCATE will not work on a locked table. Code:

View Replies !

Password Seems To Reset
It seems that the password for the root user account becomes invalid after each reboot of my operating system (Windows XP) I have to skip the the grant tables and reset the password each time. I would like to know why this is occurring and what I can do to safeguard future lockouts. I have not been able to determine if it is being accessed by someone else who is changing the root password.

View Replies !

Reset Root PW
I am using Fedora 7 with mySQL 5. something...

I accidentally messed up the root password when setting mySQL up and need help... I set the password to... well... i don't know what its set to... I have followed the following steps but have a few errors... I will put them at the end:

1. Log on to your system as either the Unix root user or as the same user that the mysqld server runs as.

2. Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, hostname, and configuration. Common locations are /var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/. Generally, the filename has the extension of .pid and begins with either mysqld or your system's hostname.

You can stop the MySQL server by sending a normal kill (not kill -9) to the mysqld process, using the pathname of the .pid file in the following command: Code:

View Replies !

How To Reset Auto_increment?
Other than droping the table is there any way to reset the value of auto_increment variable to 0 or any desired value?

View Replies !

Reset Password
I get an error when trying to reset password.

I start the db using:
mysqld_safe --skip-grant-tables &

and reset the pwd using the mysqladmin command
mysqladmin -u root flush-privileges password "newpwd"

then I got the error message:
mysqladmin: unable to change password; error: 'Can't find any matching row in the user table'

View Replies !

How To Reset Last_insert_id();
I use the the following notation to "SELECT last_insert_id();" for getting the next id in my database to do some data testing. The problem now is that if I have about 788 rows of valid data and deleted 200 rows of test data, my "next" id when I do "SELECT last_insert_id();" would not be 788. The id numbers continue to be large as if I didn't get rid of that junk data.

View Replies !

Reset Indexes
How do I reset the indexes on a table?
Because... I assume that with index skips, eg... 4-5-7-8-12... Where stuff got deleted. This code here might become inefficient?

$gotConf = false;
while ($gotConf == false){
$confData = mysql_query("SELECT * FROM confession WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM confession) AND active=1 ORDER BY id LIMIT 1;", $conn) or die ('Confession select failed');
$confInfo = mysql_fetch_array($confData);
if (isset($confInfo[text]{2})){
$gotConf= true;
}
}

View Replies !