Web-enabling The Database
After information has been added to the mysql database, how do you go about web-enabling the information to be searched by your visitors?
View Complete Forum Thread with Replies
Related Forum Messages:
Enabling InnoDB
Actually am using mysql 5.0 version, default it using MyISAM engine, but i wnat ot use InnoDB engine. I tried to change the my.cnf file with entry "default_server_engnie=InnoDB".but there is no use.
View Replies !
Enabling SSL & Setting Up A Certificate
I have MySQL 5.0.27 on XP Pro. I have not been able to find the correct syntax for starting MySQL so that SSL is enabled.I've searched the forums and the Manual. ALso, can anyone point me to a location which provides clear guidance on setting up an SSL certificate? %.9.7.4 of the Reference Manual wasn't too helpful for me.
View Replies !
Enabling InnoDB Error
I've successfully enabled InnoDB for my database but I'm getting the following error when I try and set on delete cascade for a foreign key. Error SQL query: ALTER TABLE `editors` ADD CONSTRAINT `participants_editors` FOREIGN KEY ( `account_id` ) REFERENCES `participants` ( `id` ) ON DELETE CASCADE MySQL said: Documentation #1005 - Can't create table './isimodev_co_uk_main/#sql-7d1_4c69.frm' (errno: 150)
View Replies !
Enabling Binary Log In Mysql 5.0.45
I wrote log_bin=[filename] in my.inf and restarted ,eventhough if checked at commandprompt through show variables statement, its showing log_bin =off.I tried through mysql adminstrator stratup variables also. But no change at all.can anyone tell me how to enable binary logs and further process for replication.Awaiting for your valuble replies.
View Replies !
Enabling Multiple Statements
I'm trying to execute the following multiple statements using MySql w/ the ODBC connector. INSERT INTO Sites(Hostname) values('zzz'); INSERT INTO Hosts(SiteID, Hostname) values(last_insert_id(), 'zzz'); I get the following error: [1064] [1] [0] "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 '; INSERT INTO SiteHosts(SiteID, Hostname) VALUES(@@IDENTITY, 'zzz')' at line 2" Is there something I have to do to enable multiple statements?
View Replies !
Enabling Remote Connections
Can someone tell me how to set up the mysql server to accept remote connections? Im using mysql 4.1 on Linux Ubuntu 5.10 I have tried editing my.cnf and changing the bind-address from 127.0.0.1 to the server's IP address, but this just results in the server failing to restart with the following error: Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! What do I have to do to get it to accept local and remote connections? Code:
View Replies !
Database Transfer Between Oracle 8 Database And MySQL Database
Is it somebody out there who has made a migration from an Oracle server to an MySQL server?? The scenario is as simply: I've got a Oracle 8 server with a database with content that I want to transfer to a MySQL database. No special data, constraints etc that MySQL not will handle. My solution is to reverse engineer the database from ERStudio and then produce a SQL script that will insert the data into the MySQL engine. But I can't do this, because the customer want me to do a PL/SQL script that does this, even if he never have worked with Oracle.. So the question is.. Do someone know a simplier way to do this or do I have to teach myself PL/SQL and make a script that produces a MySQL sql script ?
View Replies !
How To Apply New Database Structure To An Existing Database, Without Overwriting Data?
I am writing a simple blog software application. We released a version of this software a while ago. It comes with a sql-tables.sql file, that you can just import into your mysql database and it will setup all the tables for you, for a fresh installation. We made the sql file by just doing an export I believe, without exporting the data that was in OUR database. Well, since then several people have downloaded and installed our software, and are using it. We are about to release a new version soon, however. Since it is all still under development, many things have changed in our database structure. We've added new tables, and modified or even removed fields from existing tables. So for the new release, we're going to include a new sql-tables.sql file obviously, so that for fresh installations they can still install it just like normal. However, the question is... how do you "upgrade" all the previous version's users's databases, without losing any of their data? Is there anyway to export just the structure of our current database... then somehow apply it so that it just goes through and changes another database to match the new structure? Or any ideas at all how to do this?
View Replies !
Converting Ms Access Database To Mysql 5 Database
I've imported a ms access database into a table in a mysql database. The access database contains a field that holds date/time values in 'general date' format. These all show up at 01/01/1970 in the mysql database. I believe the field in mysql is wanting UTC and shows numbers when looked at from the sql command line (i.e. March 13, 2006, 5:31 pm is shown as 1142289086). How do I get the access data into that format so it will import properly?
View Replies !
Create Database Mysql Database In My System
I have installed MySQL 4.1.7-Standard in MacOS X (10.3.5). I have ONLY database test. According to the manual there should be TWO. test and mysql. I have re-run mysql_install_db several times with he same result. Can some mysql guru explain or point me to the right page to have this mysql database in my system?
View Replies !
Restoring Database In A Changed Database
I have a database name 'rtdb1' with a table 'review_table'. The 'review_table' has one column 'version' of varchar 20 type. I took the mysqldump of the rtdb1 database. Then I changed by table 'review_table' by adding one more column 'category' int type and called the database 'rtdb2'. But when I restore my dump of 'rtdb1' database to 'rtdb2' database, I don't see the 'category' column.
View Replies !
Database Error : No Database Selected
I am trying to install an application called weberp on my website. I have writen a script to test that the database name, user name, and password are all correct, and mysql is there and running okay. I entered a script into myphpadmin to establish the database. All the tables, and so forth, were created with no errors.
View Replies !
Extracting Data From Large SINGLE-table Database To MULT-table Relational Database
I have a very large single-table database of articles that I want to convert to a multi-table, relational database. The existing single-table database contains fields for article author, article source, and article category, where several 'author', 'source', and 'category' IDs repeat dozens of times for hundreds of different articles. I want to create seperate tables for author, source, and category and populate the new tables by extracting data from the original single-table database by unique ID field. I figured out how to use INSERT and SELECT to pull data in new tables, but can't figure out how to pull only a single instance of a unique author, source, and category to create master reference tables for author/source/category.
View Replies !
USE Database Prompt :: How To Know About A Database
How do I know what database I am 'using'? I launch mysql from the command line. Type 'show databases', then pick a database to use by typing 'use databasename'. I am now using that database but have no visual cue. How do I include the username, database name, etc in the 'mysql>' prompt? Note, I can customize the command prompt on linux to include user, host, directory, etc.. so I always know who I am and where I am.
View Replies !
Convert Ver 4.0 Database To Ver 4.1 Database
I do not know if this is the correct forum to ask this in or not. We have changed hosts and the old hosting company was running MySQL version 4.0.27 standard and our new host is running MySQL version 4.1.22 Standard. We have a database from the old host that we need to convert to MySQL ver 4.1.22 so we can use it on the new host. We were running a older version of SugarCRM on the old host but we upgraded when we went to the new host and the new version of SugarCRM will not work with the copy of our old database file. It says that it needs MySQL version 4.1.2 or higher. Is there any way to convert the old data base.
View Replies !
Dropping Database Called "database"
I have finally managed to install and configure mysql on my pc for testing but need to import data from an Access Database. I first found out that I had to create a new user and grant priviledges to it - which means I could connect. My next stage was using the migration tool to import the data. This did not go so well... Firstly, many of the table names had spaces in them which means that they are effectively useless in mysql. So I thought I would start again, ensuring that the tables are first renamed in Access. I then went to show databases and, during the migration process, it has given the imported data the default name of "database". I now have a major problem deleting it as it thinks the name is an instruction! Anyone know how to get over this issue?
View Replies !
Move Table From A Database To Another Table In A Database
I am currently developing a project as I am only a web designer. I need to move a table from a database to another table in a database. I am using SQL Server 2005 Express. How is this done? I have been stuck for months trying to figure this out! I have even bought SQL Server Express 2005 for Dummies and cannot figure this out! I need someone to hold my hand and walk me through this literally! Or give me syntax code to do this.
View Replies !
Database Pw
i've searched quite a bit, but cant find any post relating to sql command for setting database passwords. anyone know how?
View Replies !
Same Database Name
Is there a way to prevent users from creating the same database name? for example our name schema goes like: mysql_1234, mysql_32143, mysql_.... But we found out that some one could create MYSQL_1234 while mysql_1234 already exists. I guess what we need to know is that if there is away for mysql to not allow same names even though its different case characters.
View Replies !
Database Name
Is there an SQL command that i can perform which will return me the name of the Database i'm currently conected to.
View Replies !
New Database
I am quite new to working with databases and am currently having problems connecting to my new MySQL database. I have been working with dreamweaver and have been using a db on my localhost which worked fine, however now I have set up a db with an online host and I am having problems connecting to it. I go in to dreamweavers MySQL connection control panel and fill in all the details that I have been given, user name and password, and from the top of my db website which says “MySQL 4.1.15-standard running on 217.174.253.162 as stopticket@server217-174-253-162.live-servers.net” so I use the 217.174.253.162 as the server, however when I try to connect I get an error message saying “2003 cant connect to MySQL server on “217.174.253.162” (10060)”. Has any one got any idea of something I could be doing wrong
View Replies !
Database Getting Too Big
i have a mysql database which i think is getting too big! I have about a thousand records which came from a form on my webpage and I am worried that i may get complications in future if i dont do something! My question for today is how do I archive my database so that I can go back to it whenever I need to find old records? Do i just use the mysql admin console to do a backup and then delete the table contents or what?
View Replies !
Database Php
id name 1 Dad 2 Mom 3 Brother 4 Sister 5 Brother I want to use html form and php to access the database and alter it, basically delete and insert. I know how to make the html form. But I don't know how to create the php script. So far I've been using phpmadmin, it's great but I want something simple. Sergewiz, helped me with the main php element that I wish to use. update table_name set id = id + 1 where id > 3; insert into table_name(id,name) values(4,'sister');
View Replies !
Database Under Id
I want to be able to delete everything within my database under a certain ID. I know I have to use some sort of Cascading delete but not sure of the syntax.
View Replies !
CD In A Database
Let's say I have two tables Songs and AlbumSongs. Songs has SongTitle as a field and AlbumSongs has TrackLength and TrackNumber. Both have primary keys as in SongID and etc. Now I am asked to find the total length of all CDs in a database. I use the statement: SELECT SUM(TrackLength) FROM AlbumSongs;" And it gave me an answer like 20637(seconds). It seems reasonable since I know for sure that I have 6 bands in my database. Did I do this correctly? Also why is it that when I add Songs after the FROM statement, my answer is like 102356? Is it because of Cartesian whatever? Do I have to math the SongID with SongID with their respective tables?
View Replies !
Database For My Sql 4.1.14
i have an SQL database for mysql version 4.1.14 and my new shared hosting company provides mysql version 4.0.16 i asked them to upgrade the version they said that they can upgrade for shared hosting guys please help me i want to dump this database.is there anyway to convert my SQL database to mysql version 4.0.16 ? if there is how can i do that
View Replies !
Database To Use
I'm about to start a huge project, what database software should I use if I want speed? There's going to be tons of data that's going to be indexed and recalled. What database do you guys reckon facebook.com and myspace.com uses? (no i'm not doing a social network site) my friend who works for www.twango.com (gonna kick flickrs ***!) says I should use sql server, but right now I don't have the money for it...I'd rather spend that money on programming talent. Say that I did it in mysql, how hard is it to convert everything to SQL server or oracle?
View Replies !
PMA Database
Whenever i try to install a chat prog on my server i get these stupid errors through MYSQL db through phpmyadmin. Error: The additional Features for working with linked Tables have been deactivated. To find out why click here. So i click here. Error: PMA Database ... not OK[ Documentation ] General relation features Disabled. I have looked all over google for hours tryin to find a solution for this. But i cant seem to find sumone.
View Replies !
My SQL Database
I want to install the SCommerce freeware on my localhost. While this installtion, I'm asked, where's my Database and about password and username. But I haven't been asked to make inputs for these subjects. But unfortunatelly I get the return: Access denied for user 'medienwerkstatt'@'localhost' (using password: YES).
View Replies !
1 Database Or 2
I am building a website with several scripts that use MySql, Links, Forums, Photo Galleries, News Articles etc. At this point I have no idea how popular the site is going to be and how much data will be inserted into the database. My questions are these: should I put all tables in just on database our should I split them up between 2 or more? I there a difference in performance when the site uses only 1 database or more?
View Replies !
Using One Or More Than One Database?
I am doing preliminary research for a future project and would like to ask your opinions on what you suggest is best for maximum database speed as well as stability and reliability. This project would be a web store with tables relating to product info, client info, community forums, financial data, etc. The product info tables would have the most querries, potentially up to tens of thousands of hits per second. I would like people to be able to login without any delays and to get search results back on products within a fraction of a second. Would it make sense to put the product tables into their own database separate from the community forums and client info tables even if they are hosted on the same server? Would there be performance difference and/or better stability, reliability? What about having these separate databases hosted on separate servers? Would that be better than having one all-embracing large database on one server or perhaps on a server cluster? Would there be scalability issues?
View Replies !
Same Database
I have Navicat but can't figure out how to do this? I also have phpmyadmin.I just want to compare and THEN maybe make changes.It's on the same server and database but two different table names.
View Replies !
Old Database
I run a clan site and have had a problem with my web host going into liquidation. I have went with another webhost but because of this the prefix for the database is always eurozark_. The backup of my old site has a prefix of smf_. I tried to import the old database but none of the records registered on the new site. Is there a workaround for this or a way to rename the old database so that it will work in the new site. The iste is has SMF forum installed hence the smf_ prefix of the old backup.
View Replies !
Can't Log Into Database
Created a database. I go to test to see if I can gain access, but I can't. I'm using the user and pass I created for that database. What could be wrong? mysqladmin -u root -p create test_db mysql -u root -p -e "GRANT ALL PRIVILEGES ON test_db.* TO testuser IDENTIFIED BY 'testpass'" mysql -u root -p -e "SET PASSWORD FOR testuser = OLD_PASSWORD('testpass')" mysql -u root -p -e "FLUSH PRIVILEGES"
View Replies !
Where Did My Database Go?
I am taking a course in mysql, and our first assignment had us build a database and make changes to it. That went well, but since I quit mysql and restarted the computer (a Mac), I can't find my database. I can see it with MySQL Administrator, but not with my commandline mysql. macMini:~ paularchibald$ cd /usr/local/mysql macMini:mysql paularchibald$ Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 8 Server version: 5.0.67 MySQL Community Server (GPL) Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.01 sec) Before I shut down I had this: mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | HenryBooks | | mysql | | test | | world | +--------------------+ 5 rows in set (0.00 sec)
View Replies !
Two Different Database
I am a newbie and am wondering whether I can select data from two different database but in the same server, or whether move data/table from one database into another using SQL statements. Please anyone, who has experiences dealing with two different database, may share your opinion with me.
View Replies !
Two Database
i want to select two tables from two different database. is it possible? i want to know the equivalent of this code in mysql. SQLString = "SELECT * FROM StaffTable INNER JOIN datalog.dbo.Employees ON StaffTable.PinProfile = datalog.dbo.Employees.Payroll_id WHERE PinProfile = '"&Session("user")&"'";
View Replies !
|
TRACKER
