A Doesn't Get All Databases
I have an odd mysql configuration. Suffice to say that I have over 6000 databases (small ones, all automatically created).
When I run mysqldump -A, it appears that it's only getting a subset of the 6000. It's only backing up 1175 databases.
View Complete Forum Thread with Replies
Related Forum Messages:
WHERE Doesnt Equal
I am trying to select something my DB where a clause does not equal something but for some reason I cant seem to make it work. Here is what I have tried. PHP Code: SELECT * FROM golf_groups WHERE name!="something" but this doesnt seem to work. i had done something like this before and thought that I had done it this way, but since this does not work,
View Replies !
It Doesnt Use My Index!
`player_1` mediumint(7) unsigned NOT NULL default Ɔ' `player_2` mediumint(7) unsigned NOT NULL default Ɔ' reffering to users' id-number in another table. I have two indexes: KEY `one` (`player_1`), KEY `two` (`player_2`) The cardinality of them is 6000 and 7000. My primary-key has cardinality 150 000. When i run this query: EXPLAIN SELECT * FROM `gamebase` WHERE player_1 =1 It uses the "one"-key (doh!). But now, that I run my next query (using OR), it tells me that one and two are possible keys, but it uses neither, but loops through my entire table "Using where". EXPLAIN SELECT * FROM `gamebase` WHERE player_1 =1 OR player_2 =1
View Replies !
Function Doesnt Work
i tried write simple function: CREATE FUNCTION `getLastNumber`(some_guy INT(50), date DATE) RETURNS float BEGIN DECLARE a FLOAT; SET a = NULL; SELECT number INTO a FROM numbers p WHERE p.number_owner = some_guy AND p.date_created <= date ORDER BY p.date DESC LIMIT 1; RETURN a; END that would return last inserted number into table for some person. When some_guy has number in table, then is everything ok and it returns last number, but when some_guy does not have row in table it returns: Query OK, -1 rows affected. Pls why? and how to fix it?
View Replies !
GROUP BY Doesnt Work
i have a table that contains the folowing fields: some_table: company_number something_number price date_price_established for a certain company i need to get all the dates that prices were established. and i dont want any date_price_established to repeat themselfs. for example, for the following database: 1,1,15.5,1.1.2006 1,1,16,1.1.2006 1,1,17.5,1.1.2006 1,1,16,3.1.2006 the results will be : 1.1.2006, 3.1.2006. this is what i've tried: SELECT date_price_established FROM myDb.some_table WHERE company_number = 1 GROUP BY date_price_established";
View Replies !
Domain Name Now Doesnt Work
I have a software script I had installed on my server that works with a mysql database. It was working fine as far as pulling information from the database under my old domain name, however, I changed to a new domain name as primary on my server and now the database does not pull anything into the template. I know this is probably simple but not sure how to fix this.
View Replies !
Where Clause Doesnt Work
im creating a website with a mysql database. ive jus got started. im havin a few problems i have a product table and i execute a simple query but it doesnt seem to give me any results: heres the query: Select * from product where ProductName = 'Age of Empires III'; the above query doesnt work but this 1 does Select * from product where ProductName LIKE 'Age%';
View Replies !
Its Returning A Value That Doesnt Exist
Okay here is the deal. I am running a query to find out if there is an ID in my table that has a case number that matches the one being submitted. If there isnt once its should step into an if statement that would submit a number of records. Otherwise it should jump to the else statement. I the problem comes from: the query keeps returning "Record id#2" but there is no record matching the case number being submited from the form. if( isset($_POST['Submit'])){ //Begin If statement logic $resultcheck = mysql_query("SELECT * FROM submissions WHERE wfmcase = " . $_POST['wfmc']) or die(mysql_error()); //Query string to test if wfmcase was already submitted echo "Sucess, form varibles have been passed.<br />"; echo "Resultcheck query results: $resultcheck <br />"; if ($resultcheck == ""){ //Checks to see if the query was empty. echo "There are no duplicate case escalations pending. <br />"; I added the echo statement so that i could see how far it was getting through the script. It dies after printing the varible $resultcheck which gives "Record id#2". It never enters the 2nd if statement because for what ever reason the query has the "record #id2" in it... What is causing this? I have verfied that there is no case that matches the one coming from the form and i get the same error.
View Replies !
Mysqldump Doesnt Work
i try to insert the followind data to mysql database mysqlimport -u root -p anaktisi2 < phpbb_db_backup.sql But this doesnt insert anything in the db.
View Replies !
Full Text Searsh Doesnt Work
I am trying to do a Full text search, but I have two problems. 1. If I enter a word that is found under multiple entries, I get no return. But it i search a word tha's only under one enetry, then it works. 2. This query works: PHP SELECT * FROM `site` WHERE MATCH (site_name,keywords) AGAINST ('mice') AND `approved`=Ƈ' , but when I add WITH QUERY EXPANSION, it doesnt work. PHP SELECT * FROM `site` WHERE MATCH (site_name,keywords) AGAINST ('mice' WITH QUERY EXPANSION) AND `approved`=Ƈ' I get this error: MySQL said: #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 'WITH QUERY EXPANSION ) AND `approved` = Ƈ' LIMIT 0, 30' at
View Replies !
SELECT Doesnt Select Anything WHERE Doule
I am running the next script SELECT * FROM flcc_Tickets WHERE 'Match No'=1; but dont get any results although there are lots of resords with 'Match No'=1 in a table. 'Match No' is DOUBLE . if run it with 'Match No'=0 i get all the table.
View Replies !
Cant See My Databases
I don't know what the problem is here. I used to be able to install MySQL and go to this interface (please see attachment). Right-click and 'create datbase' but it doesnt let me do that. The only options it gives me is flush hosts; flush logs; flush tables and flush threads.
View Replies !
Databases
I have a small residential design company and would like to create an online database so that I can start selling my plans online. I downloaded mysql a couple of months ago and played with it a little bit and even created a small database so that I could see what it could do. But how would I go about getting a database that people could do searches on with my website? Or is there another interface that I need to install ontop of mysql that will allow me to do this easiely?
View Replies !
Different Databases
I am developing an application that uses two separate databases. Each database is hosted by our ISP on a different IP address. I would like to write a query of the form: SELECT * FROM table WHERE db1_tbl.val = db2_tbl.val where db1 and db2 are my two independent databases. I write in ASP and I have a connection string to each database. What I need to do is select records from one database with a column containing values from the other. My current method, in code, is to open each recordset in turn, convert to an array and then do a look up from one to the other, which in code is complicated. Is there any way I can do it through a query?
View Replies !
Use Two Databases
Use two Databases for authentication I would like to use two databases to authenticate users. The first database I would like to be checking usernames and passwords only and usernames in plain text and passwords to be in md5. The second database with the rest of the data the users need for privileges of the application that has to be in plain text. HOW? I have all the create scripts written but don’t know how to link the databases properly.
View Replies !
Where Are The Databases?
After having installed MySQL on a Windows machine, SHOW DATABASES shows test and information_schema. Yet, I see no files of these names anywhere in the MySQL directories. I'm curious about where it keeps them. More importantly, where do I put my own databases so I can access them in MySQL?
View Replies !
Each Set Of Databases
I would like to set up separate data directories and have mysql store data in those subdirectories. Each client would get their own directory. They would each contain the following databases: gl, 2004gl, 2003gl, ap, 2004ap, 2003ap, etc. I like to separate the database files for speed which was required when using MSAccess.Can this be done, or must I either wait for 5.0.2's schemas or redesign my database structure? I am using mysql 5.0.0 right now, but am only in the development phase, so I will upgrade asap before going into production mode.
View Replies !
How Many Databases Should I Use?
What do you think that would be better? To have 20 databases with 10 tables each database and a total of 2.000 rows in each database, or... To have 1 database with 11 tables and a total of 40.000 rows. How should I handle large projects?
View Replies !
How Many Databases Do I Need
I'm in the preparation stage at the moment of a really big project, now the project is going to entail people signing up to a website and then selling stuff online. We are looking at about 1000 people signing up to start and then growing to about 8000. The question I have is how many database's should I build the site around as there is going to be a "Super Admin" section where I will add all the products available on the site (about 15,000) and manage ad's and stuff like that. Then the person that pays to have an online shop will select products from the ones i have inputted and be able to change all his settings for his personal look to the site. Then there is the end-user who will come to the site sign up and then buy stuff, and his settings will need saving as well. So as far as performance goes would it be better to have a separate DB for each section ("Super Admin" - "User Admin" - "End User") or just use one and store everything in there?
View Replies !
Why Do Databases Goes Bad?
How often do databases go bad, and what is the usual cause? I've had flat file sites for 5 years that never had a problem, I've never had a problem with a MySQL based CMS thus far but I have with forum software and didn't know the cause. I hear of websites losing all their data from their MySQL database going bad. Is the solution to make a MySQL backup dump every so often?
View Replies !
Databases With Different Encodings
when I try to feed the dump into my server (mysql < DUMPFILE) as it is, I see the greek but I can't get the sorting correct. When I change the dump file (CREATE DATABASE ... CHARACTER SET greek) I cannot see the greek text. Furthermore, when I try to get the texts from a php page, I can't get it right either way. Any ideas? Also, is there a way to set the database encoding to something else than the default in php? I see there' s a "mysql_client_encoding" function, but no function like "set_mysql_client_encoding". And another thing. I get the utf8-encoded greek correct on php pages when I build php with "--with-mysql", which uses Client API version 3.23.49. If I build it with "--with-mysql=/usr/local/mysql" (where I have installed MySQL 4.1.5) yielding Client API version "4.1.5-gamma" in phpinfo(), I also get the greek text wrong (every character shows as "?"). Is there something I should configure at the Client API, and how do I do that?
View Replies !
Backup My Databases
I made a question several days before to describe my strange trouble of mysqldump. But I still can't figour it out. Well, I just want to ask another question whether I could just backup my databases by copying the data folder to some place? Then if I meet some disaster, could I just copy the backup folder back to recover my databases?
View Replies !
Show Databases
I just installed MySQL on my home PC and I tested out the show databases query, and it lists two: information_schema bbdatabank The second one is one I created myself, but I don't understand what the first one is. It is not listed in my 'data' folder, but mysql and test *are*, yet they aren't listed when I type the show command. Why is that? How can I get them listed so that I can use them, and what is the information_schema?
View Replies !
Large Databases
We are in the process of building an application to front end a database of about 2 million records. I would like to know if MYSQL can handle this and if not, what would be a good database to go with. We would like to use opensource as much as possible, but if MYSQL cannot handle this kind of volume then we will have to go in for commercial software.
View Replies !
Unable To ADD Databases
I'm just started the process of learning MySQL and databases in general. I just bought the book 'MySQL' written by Paul DuBois, who I gather is really active in this community. Anyhow.. Here's the problem that I'm having. mysql> GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDENTIFIED BY 'secret'; Query OK, 0 rows affected (0.00 sec) mysql> show databases; +----------+ | Database | +----------+ | helpdesk | | mysql | | test | +----------+ 3 rows in set (0.01 sec) Anyone notice the problem? Even though I get no error.. the sampdb is not being greated. This is weird as I've been able to use this exact command in the past with no problems. I even tried logging in as root before starting the mysql client, still made no difference.
View Replies !
Linking Databases
is it possible to link databases within mysql? I have a access = database that I need to import into mysql this db consists of 4 other = dbs linked together sharing a common switchboard. Can I link the tables = in one db to tables in another db?
View Replies !
1 Username Databases?
Many ISP:s offer web-service with MySQL - with 1 user / 1 database. Have I understood right that this means there is that 1 read/write user only, and no chance to make read-only username, so only chance is to put username/password with write-rights into scripts?
View Replies !
Location Of Databases
It creates a folder for 'data' under c:mysql. If I want the data to reside under my local internet root directory, how do I tell Mysql where to find it?
View Replies !
Merging Databases
Suppose I have a relational database, called "BranchA." I have a second relational database, of identical structure to BranchA, but with different data, and this one is called BranchB. Can I merge the two, into, say, a BranchC somehow on occassion?
View Replies !
Mapping Two Databases
I have a MySql database I connect through using mysql-connector-...jar under java. I need to co-exist with another MySql database in order to get this one job wherein the fields of the other database can map to fields in my database. For example, they have a customers table as does mine. There may be some differences in the fields and such, but, in broad strokes, the tables are redundant. I cannot, however, rewrite this application to use their format - both tables need to coexist. So I am wondering if there is not an accepted means to monitor changes in one database/table and forward those changes to the other database/table on an ongoing and real-time basis. Does such a procedure exist?
View Replies !
2 Databases With 1 User
I am trying to run a script that needs one user with two databases. My hosting company have told me that i need to create 2 databases and 1 stand-alone user in my hosting cp, then with phpmyadmin i need to grant access from the 2 databases to the stand-alone user. I have been reading through the mysql website for ages and trying lots of things that don't seem to be working. I am sure this would be very easy for someone who knows what they are doing! Is there anyone who could give me step by step instructions, or if they were feeling really generous i can give them access to the cp and they could do it for me!
View Replies !
How Do I Reconcile 2 Databases
I had a database with about 2 1/2 years of data. I was told to go through and delete everything older than 2008. Easy enough, considering the information is timestamped. Afterwards, I found out people still needed to access this data. Oh boy. Being the good admin that I am, I of course made a backup of the database before purging. While I was able to provide the people with the information from the backup database, it's now become a daily task of finding old data. While I could put the old data up in a seperate application, I know this will just lead to problems and confusion. What I was wondering is if there was anyway of taking the backup database, the current database, and combining them into a single database? I can't just input the .sql file, because there's data on the backup that's also on the current database. In addition, to possibly make matters worse, I ran an "OPTIMIZE" on each table.
View Replies !
Recover Databases
I was able to recover what appears to be the MySQL data folder from my hard drive (which was in a Ubuntu 6.06 laptop that just got it's motherboard fried). It has the databases names as folders with .myd, .myi & .frm files inside them. How do I restore/import my databases?
View Replies !
Backup Databases
right now I have a couple of databases on my computer, and I need to back them up to a disc, but I dont know what commands to us. I have been googling for about 10 minutes and still havnt found anything.
View Replies !
Combine Two Databases
in MyphpAdmin i have two separate databases, one for a script called gcards, one for phpbb. what i'd like to do is cross reference it so that members could send cards without necessarily knowing another member's email addy... but to do this, i'd need the gcards to draw upon the user info in the phpbb. is this even possible? i found this other thread from last year, but if this is talking about the same thing essentially, i'm too sql-illiterate to understand how i'd do it....
View Replies !
I Typed S And It Said No Databases
How would I make a page on an Apache2 Server running off my computer connect to a MySQL Server also installed on my computer? And I think I have a database but when I go to Command Prompt it says "No Database" how would I fix this.
View Replies !
Insert In 2 Databases?
i have this login script and i want to make a page for profile the the user see's. now whe the admin creates a user it inserts the info in my database. what i need to know can it insert in 2 places at the same time?multiple databses?
View Replies !
Joining Two Databases
I have two tables in two different databases, there is a simple SELECT query I want to run, joinging both tables. There is a secondary key that in both tables, however I am not sure if a. its possible b. how do actually write the join.
View Replies !
Link 2 Databases
i have 2 catalogues on line and one of them my partner made a datasinc to sinc the catalogue information to his access databse(pc) so the stock would always be up to date. now i got him a second catalogue for retail sales and we have the same products. my question is since the both databses or on the same server is it possible to link both 2 keep the stock up to date on the other one?
View Replies !
Mulitple Databases
Does anyone know how you can set up multiple databases to have the same login with in Linux? I.E: Databases named: DB1, DB2, and DB3 would all have the same login name and password.
View Replies !
Web Hosting Databases
Many times we want to be able to manage our databases stored in the web hosting but these only can be manipulated with the PhpMyAdmin.PhpMyAdmin is a simple but useful tool. To people that use MySQL Clients a very good alternative it is the SSH Tunneling, throught this one we can carry out connections to web hosting that supports SSH. SSH can be used to encrypt communications between MySQL Client and your remote MySQL server in your Web Hosting.The prime benefit of SSH tunneling is that it allows us to connect to a MySQL server from behind a firewall when the MySQL server port is blocked.
View Replies !
Data From 2 Databases
I have two databases... dg_reviews and dg_articles.... currently i am pulling three random entries out of dg_articles.reviews and displaying them... problem is that i now want to filter the randomness down to being genre specific, problem is the genres are stored in dg_reviews.reviews. The main similarity between the two databases is that they have the same exact ID entries for each entry. Is there a way i can match these and filter by genre?
View Replies !
One Or Multiple Databases
is there any performence-effect whith the way that tables are assigned to databases?? i.e. i have to options to eiter create several databases A, B, C and in each database i have tables x, y, z. instead i also could do only 1 database and call the tables A_x, A_y, A_z, B_x, B_y, B_z, C_x, C_y, C_z. brings me any of those options any performence advantage? I use all tables permanently all day.arranging them in different databases gives me a better systematicly overview. but then i permanently need to switch database.
View Replies !
Accessing All Databases
I have a problem everybody who has a username and password can access to all databases even mysql database (the one which user details are in it) and able to delete or edit any data. I thought mysql is on skip grant tables mode but I did reload or flush-privileges nothing changes.I manualy go there any set all privileges to that user N but that user still able to access only mysql database and this is very dangerous because they can edit or delete any user. I tried to delete user and any user can delete any user yes. In that case I need your help what command I need to write to fix this problem.
View Replies !
Security In My Databases
I am the root and I have 4 databases: 3 private and 1 public. I have a user (david), and I want david to access only the public database. We are using SQLYog frontend and I´ve tried a lot with grant and revoke commands, flush privileges, and others to avoid david watching any of the 3 private databases. When I try to log using david's login I'm able to watch everything in the 3 private databases. I don´t want david to watch neither structure nor data in any of the 3 databases.
View Replies !
Switching Databases
I have a vbulletin forum right now and would like to switch to phpBB. But I cannot loose any members or posts. Someone told me I can switch the vbulletin database with the phpbb one, or import everything to phpbb from vbulletin(except the hacks/mods). Is this even possible? Is there a program for it?
View Replies !
Sync Databases
I have a database on a production server, and a seperate one on a development server. Up until now, I have been doing a mysqldump on the DB on the production server, SFTPing the file to the development server, and then running mysql dbName < filename.sql is there an easier way to do this? I guess I could use a shell script, perhaps including some expect for the remote server work. But is there anything either builtin to MySQL or as a simple third-party tool which, without creating a temporary file, copies the database from one server to another?
View Replies !
|
TRACKER
