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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 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 !
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 !
Transfer Databases To New IP
I have about 20 sites that I have to transfer from my old resellers package over to a new dedicated IP that I just got. I have the sites all uploaded, but not the databases. I can export the database.sql text files from each site, but how do I install it on the new server?
View Replies !
Databases Are Not Loading
I am using Mysql 4.0.18. I load my database (tele) in "data" directory at c:mysql. The first time, I opened WinMySQLadmin and 3 databases appeared: test,mysql and tele. It was Ok. Then I restarted my computer and I went to WinMySQLadmin again and didn't appear mysql and tele database. What I am doing wrong or what is the problem?
View Replies !
Subdomain For Certain Databases
if it's possible to create a subdomain for certain databases. For example, let's say you wanted to start an online photo gallery service. People could create an account on the website (enter their desired username and password), and the PHP script would take this information to create a database for them to use to store all their photos. Let's say the database name is their username + "_db" and they are given two tables, "Pics" and "Movies". If 5 people register, you might have the following databases on your server (last five are the clients): mysql information_schema test bob_db andy_db frank_db emily_db tony_db Is there any way to group these client databases more nicely? For example, have a "client" namespace and put them there? Just some way to keep them more neatly separated from whatever else is going on on the server. I suppose the alternative would be to just create a single database called "clients", and then create individual Pic and Movie tables for each user (e.g. Bob_Pics, Bob_Movies, Andy_Pics, Andy_Movies, etc etc.
View Replies !
Sync 2 Databases
I've recently ran into issues with my web hosting server (not in house) so I am wanting to set up a local machine with an exact replica of information from the hosting server. Is there any function or "simple" way to sync 2 databases on different machines - outside of manually updating them? I have to perform this operation once or twice an hour so manually updating the information is gonna get bothersome real quick.
View Replies !
Managaing Databases
WAMP5 1.7.2 with Apache 2.2.4 PHP 5.2.3 + PECL MySQL 5.0.41 SQLitemanager 1.2.0 phpmyadmin 2.10.1 Windows XP pro sp2 Im playing around wiki a few types of databases (wiki, phpBB, jabber, ) im having issues managing the datas, sqlitemangager isnt working phpAdmin does show me the database info. One thing i noticed setting up my DBs, i always had to use root for my wiki phpBB to talk to the DB file, i kept making accounts on sql command prompt. I guess there isnt a program like access where i can see my data structher. So the console is how to use mysql i figure. I do know ; create database name; thats about it, made a user or two, cant define admins to the default login of the databases
View Replies !
Importing A .SQL Into Databases
I'm trying to upload a .sql file for a program of mine that says I need to import it into the database I created for it. But the thing is using the source (.) command then the file name doesnt seem to be working I will type the name in and it always gives me this message. mysql> . antrix.sql ERROR: Failed to open file 'antrix.sql', error: 2 I always get this error. And I can't figure out why. But all I know is when I open the file without the sql tryin to import it. Where I just open it with notepad it gives me the things it does for the tables and so on. But it would take me weeks or so to put all that information in. So I wanted to just add it in by importing so it wouldn't take forever.
View Replies !
Sample Databases
I am new to MYSQL and im trying to learn it. How do I load the sample databses (sakila, world) into a table. How do I create the tables for these databses.
View Replies !
New User Can't See Any Databases
I'm starting with administrating MySQL, and the first problem arises. I installed MySql and everything works fine. With the root-user I can do what I want. I created a very simple DB with three tables and a new User (via PhpMyAdmin). He has no global rights, but SELECT, UPDATE and INSERT rights for my test-db. I can connect with my testuser to the server, but he is unable to see my test-db (SHOW DATABASES return empty set)... which right did I forget to grant him, so that he can see and use the test.db?
View Replies !
|
TRACKER
