2 Websites Using 1 Database
i have two logins systems(for 2 websites) and i use the same mysql database.
still now when the users login at the first site and link to the other,they have to login again to access it.how can i manage this so when someone login at the 1/2 sites,they apear online at the other without needing to login again?
note that:
*i use the same database for these two sites
*i use one url and users switch between these two sites using internal button link.
*both sites r in the same server.
View Complete Forum Thread with Replies
Related Forum Messages:
Using One Database By Two Websites
I am with 1and1 and am trying to put together three small websites. Obe for my local church, mine, and a friends. At present I have access to two databases but I would like to share one as the cost is prohibitive to add another database. Is there a way in [for example] .htaccess or by putting in a "directory" that could sort this out.
View Replies !
1 Database For 2 Websites?
While I have been doing simple HTML and CSS websites for some time I just recently started out with PHP and MySQL. The question I have is I have an existing website which runs off a MySQL database and am in the process of creating a second site which is the EXACT same type of website (myspace resouce) and will be using the exact same scripts on both sites so rather than having to create a second database and updating two seperates sites all the time if I can run them both off the same database so that by updating one database both sites will update with the new content. Also the only things that are run off of the database is non search engine friendly content such as myspace layouts, graphics, and other types of images but the pages text content for each site is unique.
View Replies !
Access A Database From Different Websites
Is it possible to access a MySQL database from a domain other than the domain that the database is phtsically on, and if so, how? For example, if my database is located on www.site1.com, and I want to access it from a script on www.site2.com, how do I do it? For arguments sake, assume both websites are physically located on the same server, and they share an IP address of 123.123.123.001.
View Replies !
Two Different Websites Connected To One Database But Only One Works...
I have been recently having problems transferring my website from one domain name to another. The first domain name was used whilst at uni, but the second is my own perosnal website. One the original website, the MySQL database allows the user to login and register new users without any problems. However, the second website does not allow me to do this. I would consider myself a newbie when its comes to MySQL so I was wondering if the community could help me out on this one. Both websites are hosted by the same company, and both websites use the same database but my limited knowledge cannot solve this problem. Are there certain permissions I need to set or something? Can anyone help me out on this one?
View Replies !
Some Advice For A Newbie On Big Scale Websites Like Ebay, Facebook, Youtube
I am literally newbie in database design. Just finished kevin yank's build your own database driven website using php and mysql. The book helped me to understand the imporatance of deisgn in a database driven site but I still finding it difficult to figure out the large scale websites like ebay, facebook or youtube. Does anyone know how the database might be designed for these sites. Facebook and youtube are tagbased sites where everything is connected by tags. but how are these tags organized in tables?
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 !
Id From Database
I'm programming a photo database with perl and mysql where every user should be able to post some comments to each picture. so i've got two tables one with all the picture data and one with all the comments. my problem now is: How do i get this data together. My solution till now is: Each DB has a field called ID. an in the pictures database i got a field comments. there i'm saving alle comment-ids according to this picture separated by two semicolons so a pictures with 3 comments has a value like 1;;4;;283 in this comments-field. Like this i can read the field separate the ids an get the ids from the database. This doesn't look good to me. Is there any other easier possibility to do that.
View Replies !
Specifying Database Name
I executed a sample jsp, connecting mysql using connectorJ with tomcat.It works fine but it i need to know where I can specify which Database it should use. where can i specify the name of database .
View Replies !
|
TRACKER
