Virtual Domain
I have a dedicated server with 5 virtual domains under iis.
i just installed mysql. how do i create a separate instance of mysql for
each of my virtual domain so that one domain affects only tables created by
that domain and not step on tables of other domain?
let's say that each virtual domain is a separate web site with different
fqdn
View Complete Forum Thread with Replies
Related Forum Messages:
Mysql To Virtual Domain
I have a dedicated server with 5 virtual domains under iis. i just installed mysql. how do i create a separate instance of mysql for each of my virtual domain so that one domain affects only tables created by that domain and not step on tables of other domain? let's say that each virtual domain is a separate web site with different fqdn
View Replies !
Virtual Fields
Is there a way to do a mysql select with - for lack of a better word - a 'virtual field'. In other words, I'd like to select on a field that is based on the contents of other fields. Like: If field A is greater than field B, select field A, otherwise select field B Specifically, I'm working with date fields. I have a table of events where there is a start date and an end date. Most events are one day only, so they have only the start date. I would like to select and sort on the latest date field - either the end date or, if there isn't one, the start date.
View Replies !
Db On A Virtual Web Server
i am running my web server with dsvr.co.uk. a uk based web server hosting company. I am trying to use a piece of software called smoothflash at the moment to show pics. dsvr have informed me that I have mysql on my server but i cannot for the life of me work out how to connect to a db, een to create a new db. www.smoothflash.com has the install manual on it and it all seems to straight forward. I know I have enabled mysql on my server, this has been varified by dsvr. but then I have no idea how I am meant to create a db, connect to it, i have mysql admin for windows but without knowing how to create a db, get a user name and password for it i have no idea how to get any further, if any of you clever people out there could help me in this matter i'd forever be in your debt.
View Replies !
Virtual Column
I want to get users informations from multiple tables and each user has many dependants (in tbl_dependants) and the dependants table has user_id foriegn key. Is it possible to SELECT user informations and beside the user results I create a virtual column contains dependants names for each user?¿?
View Replies !
Virtual Folder
in my database i have a table which stores a directory structure folderstructure table id, foldername, parentid parentid points to its parents "id" (:p ) i need to retrieve this info so that its sorted by foldername and its children are listed below also sorted by foldername; there can be a infinite amount of nested folders.... im not really sure how to go about this; i was hoping that maybe theres some magical sql statement that can do this for me i sort of dont want to put this info in a array then sort it with recursion (which i tried and failed), nor do i want loads of sql queries
View Replies !
Using Virtual Column In WHERE Clause
SELECT IF( some_id > 3, 'foo', 'bar' ) AS 'virtualcolumn' FROM table WHERE virtualcolumn = 'foo' MySQL will complain that 'virtualcolumn' is unknow in WHERE clause. However, if I have another query like SELECT IF( some_id > 3, 'foo', 'bar' ) AS 'virtualcolumn' FROM table ORDER BY virtualcolumn ASC .
View Replies !
Not Working With Virtual Host
I set up a virtual host with Apache and my previously-working MySQL configuration now will not work! I did this a long time ago and can't remember how to fix the problem...Do i need to change some configuration so that MySQL runs on the virtual host and not localhost?
View Replies !
MySQL Virtual Hosting
When you create a new user, let's call him "userJohn", is it possible to set a different data foler for that user? I was thinking it would be great if you could keep user databases seperate from each other, kind of like every user has thier own folder on a virtual database folder, and access can be restricted for that user to the databases in their folder. So if user1 creates a database named "Database1", and later user2 creates a database with the same exact name, it will not give an error, and when user1 alters his "Database1," it will not effect any other users "Database1". Similair to webhosting, where every user has their own folder they keep thier data in.
View Replies !
Chew So Much Virtual Memory On Windows?
Have a fairly busy MySQL server using MyISAM and InnoDB tables on Win 2003 with plenty of available RAM (total 4GB, with about 1.5GB unused) which is using a massive amount of virtual memory despite having tweaked MySQL to use as much memory as it needs. RAM usage never gets much above 400MB, however Windows is reporting that MySQL is using a massive 1.5GB of virtual memory. Most other processes use a similar amount of RAM and virtual memory, so why would MySQL be using 4~5 times more virtual memory than physical memory? Especially when there is so much free physical memory?
View Replies !
My Domain Name
I've been trying to get MySQL to work for the last week. I've tried looking all over the web but nothing seems to work.My domain name links to a directory on my home computer. I'm running Windows with Apache, PHP, and now MySQL. Apache and PHP work fine and I can connect to MySQL on localhost, but when I try to connect to (my domain name) it keeps giving me the "can't connect on 10061" error. I'm entering "mysql -h (my domain name) -u guest -p". I made a user named guest and as I said, can connect if I use "mysql -h localhost -u guest -p." mysqld.exe is running as a service. Window's firewall is disabled. Can't connect using mysql_connect in PHP either.
View Replies !
Can I Have My Db On Different Domain
I've goto migrate a website to a new server, is there anyway (in the connection string) that i can continue to reference the old server (which houses mysql) and have the website on the new server and then be able to switch the connections strings when we are happy with the migration and we don't lose that much data.
View Replies !
Mysql Db On Another Domain
www.domain1.com has a script that saves the last login of users. the script needs to save to a mysql DB on another domain's DB table (www.domain2.com - MySQL DB). Password and user for domain2 DB is provided. is it possible to connect/save data to a mysql db on another domain
View Replies !
Store DB For Each Domain
if there is a way to set up MySQL server to keep DB's for one user in it's home folder? I wonder how those virtual (shared) hosting companies set it up? What I mean is say if I have two users (domains) on the server they will have all their files in their home folders. /home/domain1.com/ /home/domain2.com/ I ask this because I find it neat to have all the files for one domain in one place - mostly for backup.
View Replies !
Domain Values
I have table which has a column called URL, in which different formats of urls are stored. I want to read hostname, www.domain.com, from url column and strip out remaining data. I was reading regexp manual and i think it cannot be use before WHERE clause e.g select url regexp '' from table but at the same time i saw this functionality on another website so it is doable.
View Replies !
Removing A Domain
I added a new domain but by mistake i inserted an incorect username from what the client wants. how can i change it, or remove the user and redo it.
View Replies !
Transferring Of Domain
I would transfer a domain from an hoste to another, and I'dlike to transfer databases, also. I encountered someproblems with phpMyAdmin, and I thought: IT IS POSSIBLE TO CONNECT TO A SERVER AND BACKUP A DATABASE WITH MYSQL ADMINISTRATOR, or another MySql tool? How to configure the connection?
View Replies !
Accessing MySQL DB From Another Domain
what is the best way to access data in a MySQL database on one domain from a PHP script on another. We have a secure (SSL) server on one domain which will be used for secure credit card transactions. We would like to be able to extract insecure contact information from MySQL database on another domain in another hosting environment.
View Replies !
Storage Of Domain Names
I'd like allow user to enter domain names in a form and then to store these in a table field in MySQL.Googled this bigtime butdidn't find anything on it. What I would need is the regex poliching of the domain names (I guess I cannot put slashes into the database without caution, right?
View Replies !
Configuring XAMPP In The Domain
I am installing my XAMPP in my pc. It works fine. Everything works. My question is, is it possible to install XAMPP inside in my domain e.g., www.mydomain.com/xampp. Please help me to configure it using the domain, not in the localhost.
View Replies !
Regexp Matching *.domain.com
I don't think this is possible, but perhaps it's just beyond me? I have a database of domain names. other1.com *.test.test.com test.com *.other2.com How can I validate domain name search like "test.com" = valid domain "other.test.com" = invalid domain "other.test.test.com" = valid domain Here's my attempt, but i'm not even close. SELECT * FROM `dns` WHERE `DNS_Lookup` REGEXP ^([^.asterisk.])([.period.])(".$_DNS_SEARCH.")$';";
View Replies !
Grant All Privileges On Domain
how do i grant the privileges for user on the domain?? this one for a specific ip adress GRANT ALL PRIVILEGES ON *.* To root@'192.168.0.112' IDENTIFIED BY ''; how to make it for the domain?
View Replies !
Cannot Connect To Mysql On 1 Domain
i have several domains all connecting successfully to mysql, but recently, 1, has refused to connect giving the dreaded "1045 access denied etc" message. I have made a new user granting all privileges, but stll errors. i have tried connecting with: mysql administrator, dreamweaver amongst others. any help or guidance would be gratefully received as i need to get this sorted quickly as i cannot see where else to go with this. cheers MySQL 4.1.22-standard
View Replies !
MySQL Domain Deleted
I have Windows 2003 server Web edition and use PLESK. Yesterday a domain was deleted using PLESK. Under this domain I had created MySQL user and this user was deleted too when domain was gone.
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 !
Using MySQL/PHP On Someone's Domain.
You know if you wanna connect to mysql through php in the localhost you just do: $db = mysql_connect("localhost", "user", "password"); mysql_select_db("database", $db); Now.. what if I wanna put.. lets say the database on a web space I got from my ISP. Questions are: Which files do I need to put on the webspace? How do I connect to it? Do I need to do anything first?
View Replies !
Rename Domain Name In Mysql Database
In certain table I want to change the word mydomain.com by mynewdomain.com everywhere it appears, any column, any row. Is there a way to perform this without downloading the table, making the changes and upload it again?
View Replies !
General Log For Single Database/domain
Is it possible to have general_log setup for a single database or domain on a server with multiple databases and domains? I would like to monitor a single domain, but it's not required for the entire database server.
View Replies !
Query For Attribute Type/domain
How can I find out the type of an attribute through a SQL query. For instance, if I have a table and one of it's fields/attributes/columns/whatever is "name" and is of type "tinytext" how can I, through a SQL query (such as mysql_query() in php) get "tinytext".
View Replies !
LOAD DATA INFILE (using UNC, Windows Shares) On A DOMAIN Controller
Since we migrated MySQL on a Faster and Better Server we have some problems with LOAD DATA INFILE and OUTFILE command. Since this could be a permission problem i really don't know.... example. 1 load data infile '//server//myfile/test.txt' into table a; got errno: 13 if i remember correct FILE NOT FOUND. however typing servermyfile in Start->Run Works ok without authorization. MYSQL-SERVER: Mysql is on Windows Server 2008, All network passwords are saved inside OS on user accounts. So I tested that in Windows and Shares All Fine. -this machine is not on a DOMAIN. But authorization works ok with saved passwords and user names Server: (where the file is): Windows Server 2003 SP1 SBS Domain Controller , AD. Other App, Main APP whitch is 32bit uses MySQL on that other server there... -all works fine but UNC paths and authentication does not seem to go... -tryed some tricks... not sure if it will work... I'll try on Monday... However: I tryed to Use My Linux machine that has Samba installed. And i got there some anonymous shares that do not require any authentication at all. And MySQL works fine at that point. LOAD DATA INFILE executes fine.... samba log : mysql connects using UNC without any user name or password.... did not find any kind of user name or password sent using this method.... Maybe MySQL should just add this kind of function to my.ini..... I'll write if I find a solution fast on Monday.... Since I think this is more of a PERMISSION problem on Windows.... Should installed Linux on that machine though!:(
View Replies !
User@localhost And User@domain.com
I have been following a tutorial for a mail server which uses mysql, mainly postfix all through the tutorial i have been asked to put a user and password in the files for the database.. which i have done root and pass1 in the log files the error shows as warning access denied for user root@domain.com ( using password : yes ) when i log on from the shell, to mysql and purpously get the password wrong, I get access denied for user root@localhost ( using password : no ) i have checked the password is correct.. is the part after the @ the issue, and how can i tell mysql that root@domainname.com is a valid user???
View Replies !
|
TRACKER
