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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
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 !
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 !
Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the site performance is very slow on windows. I dont know the exact reasons. I have seen some benchmark details on internet. But still they are not having concrete facts to support LAMP as a better alternative to WAMP. Allmost all the search done on google melts down to IIS vs Apache, My main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly for PHP/MySQL.
View Replies !
Lost Connection To MySQL Server During Query (LAMP Server)
I recently installed an ubuntu LAMP server for my website and upon trying a script that uses a mysql database (which I set up the tables via phpmyadmin) and I get this error: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/tanner/Desktop/bot/DoctorWho/db_connect.php on line 4 I've searched the forums and I've gotten no answers. Anyone know the answer?
View Replies !
Lost Connection To MySQL Server During Query / Server Has Gone Away
All of a sudden the server stopped working. When trying to execute a simple INSERT both from PHP and Query Browser, the server crashes and I get either "Lost connection to MySQL server during query" or "Server has gone away" errors. The problem started on 5.0.18, and upgrading to 5.0.41 didn't help. I'm using Windows XP SP2. I've seen quite a few posts on similar problems, but no real solutions though. Is that a bug?
View Replies !
Mysqldump From Server To Server OR Move Folder /var/lib/mysql?
I need to move db's from a live server to a new server. The new server will be replacing the existing server once it's setup, and I need to move the DBs in order to do the testing. My question is this; if I use mysqldump to get a dump of all the DBs on the existing old server, and then import that .sql file to the new server, will that copy over *EVERYTHING* i need to get the DBs working again? Privilages etc ? The alternative that I am considering is to move the /var/lib/mysql folder along with mysql.cnf. That should work, as we can change any locations in the mysql.cnf file, but it does mean taking the server offline while we tar the databases, which could take 30 mins or so.
View Replies !
How Do You Manage Changes From Development Server To Production Server?
What started out as a simple test of mysql has turned into what is quickly becoming a replacement for our entire business system and web site The bad news is that we are now wrestling with how to we continue working on development the system without risking down time for users. If we work on a development server, how can we log the changes to table structure and then apply them to the live database on the production server when we are done testing? Is there some sort of tool or log that would just let us apply table structure changes to another copy of the database?
View Replies !
Access Denied For User From Server A To Server B
I'm trying to connect from Server_A to a db on a separate server, Server_B. I granted privileges to 'user' on Server_B using the following syntax: GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; But, it still yields this message on Server_A: Warning: mysql_connect(): Access denied for user: 'user@111.111.111.111' (Using password: YES) I verified that the password is correct, and I also flushed privileges after executing the above command.
View Replies !
Ugrading Win2k Server To Win2k3 Server
I would like to know if there is anything I should watch out for or do before I upgrade my Win2k server to Win2k3 server. I am running MYSQL version 5.0.27 and PHP 4. Which I must admit was a bit of a challenge finding the right combinations of the 2 that work together very well for my setup.
View Replies !
SQL Server 2000 To MySQL Server
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this: Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow. The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above.
View Replies !
Mysql Server And Regular Server
I recently decided to get another server to do just mysql, however, I ran into a few problems. As soon as I switch the script to pull from the other server it creates a huge lag between the two and eventually starts timing out the sites. in my.cnf i did do skip-name-resolve but still the same thing. Are there any programs or anything that are maybe bottlenecking it because the site will load in the first 10 secs after i switch the mysql (with a lag) but that lag gets bigger and bigger. The mysql error log doesn't show anything weird either. To further complicate things, another server that was pulling off it worked for the first few hours, then when traffic started to increase, it started doing the exact same thing. (both server loads were low and max connections was not getting even close). Roughly 600 qps, half to HEAP tables.
View Replies !
Mysql Server On A Remote Server
I have recently installed a mysql server on a remote server machine. It has 197.0.3.57 ip address assigned to it, and i believe the port it is using is 3306. I have also installed a mysql command line client on my PC, and successfully launched it. Now i have: Enter password: But how do i get connected with the remote mysql server, it seems the system is asking me to enter localhost password. What sort of client package shall i install other than commnad line client if any? and what command shall i invoke to get me connected?
View Replies !
Web Server Ram
How do I calculate the memory needed by a webserver (APACHE) connecting to a mysql server (different box). Is this only related to the select() operations / data transferred to the webserver? On the mysql server I assume that I have to calculate the max tabel size X the number of connections.. but I'm not sure about the web server size.
View Replies !
Different Server
we have a client who we're designing a website for and we have a shared server so we thought we'd just host it there but we DON'T want to handle their email so I'm assuming this means they're going to have to stick with their current host right? Well ok, but we want to make use of a MySQL database but this would sit on OUR server...so how do I go about this? Couldn't I just replace the 'localhost' with 'someipaddress/whereeverthedblives' or something like that? The only other thing I can think to do is to have the specific page that holds the db information actually live on our server, but look like it's living on the same server as everything else.... I'm not even sure that would work....but regardless, I don't know which way to go.
View Replies !
Server
My MySQL server is accessible only through the socket file (I believe). netstat -lan yields: cac1bc82 stream 0 0 c1e37378 0 0 0 /tmp/mysql.sock I can't figure out how to get mysql to listen on 3306. I would like MySQL to listen on 3306 automatically upon boot. I have gone to mysql.com and have tried everything i can find there.
View Replies !
Server A To Server B
I am a web master who up until about a month ago had only worked in ASP using Acess Databases. Now I have a client (in Austria) who I redid his web site using PHP and a mySQL database. To access the his db, I browse to a web site, log in, then manipulate the database that way. I just set up a new hosting account in America and am baffled at how I transfer the database from the current server to the new one? Do I somehow export and import the database? Is there a file created so to speak?
View Replies !
On A Different Server
I need to know how do I place my databases on a different server on a different machine(a very remote machine.). Are there some files that I can just place in some particular directories?
View Replies !
UDF Server 4.* 5.*
I noticed that behavior of "create function" depends on server version. Using connection with empty database name In early versions we do not need to write database name befor function name, but in 5.* we MUST write some, eaven if we realy don't have such database. Question is: Am I right? and From whoch version such behavior appeared.
View Replies !
Do I Need A Server?
Our company is considering putting our work order and invoicing systems on-line. We are thinking a MYSQL/PHP development and install would be a good fit. My boss, the owner of our company, mentioned this to the computer tech that services our hardward. He told my boss this idea is a very poor choice and one of his reasons was we would have to purchase a $4,000 server to run a database. Currently we are using an Access data base with Visual Basic, I've done all the programming. The size is approx. 107,000 KB, a very small data base. Also I've already built a small MySQL data base on my home computer with no problems. Can someone explain what exactly we will need as far as front end hardware to accomplish our goal? Do we need a server? Anything else?
View Replies !
Server Name
I have MySQL installed at www.mydomain.com/phpdirectory/ I have a php application that needs to connect to a database I created and it is asking for the database server name. When I log into MySQL admin panel it says Server: mysql via TCP/IP. When I click on "Databases", at the top of the screen it says "Server: mysql".
View Replies !
Best Server
Could anyone answer my questions : 1. Can VB applications on Windows clients (workgroup) access MySQL on a dedicated Linux server ? If Yes, could you tell me how to set the network for it ? 2. If my application should run from a windows client, using MySQL, Which server is the best ( speed,stability, ease of opration and cost ) for running the database : a. Dedicated Windows server 2002 b. Dedicated Windows XP
View Replies !
How Do I Set Up The Server?
I have tried installing both MySQL and DBDesigner4 but am confounded by the request to sign in - Invalid Username / Password So, can anybody tell me how to set up the program so that I can start working with a database? Are there online manuals anywhere?
View Replies !
My Sql Server 5
I'm trying to connect to a Win XP instalation of Server 5, from a win 98 PC over our working LAN. The PC's can ping each other and can browse files on each other. I can connect to the sever from the XP PC, under MySQL and ODBC. The Win 98 PC has the ODBC 3.51 connector installed. I can't even get the DSN to connect un the the Create Data Sources.
View Replies !
SQL Server
I have used PHPMyAdmin and MySQLFront for connection to MySQL to create and manage tables. What tools would I use to connect to a MS SQL Server Database?
View Replies !
Replication On Only One Server
I am searching on documentation and on web and on groups but I can't find an answer to my question: I want to use replication from one database on one server to onother database on the same server. Is it possibile? The only information I found is that it is possible if you setup 2 servers on the same machine but I don't want to do so. Is there another way to do it? Or maybe someone has a suggestion to solve my problem?
View Replies !
SERVER From Pid File
we installed a mysql vr standard-4.11.22a-pc on a machine with ubuntu breezy badger as os..after the installation we are trying to start the server by typing :bin/safe_mysqld...but it shows us a msg whch states Starting mysqld daemon with databases from /usr/local/mysql- standard-4.11.22a-pc-linux-gnu-i686-glibc23/data followed by... 'STOPPING SERVER from pid file /usr/local/mysql-standard-4.11.22a-pc- linux-gnu-i686-glibc23/data/linuxserver.pid mysql ended' i have used the chown command already (chown -R mysql data)...but it still doesn't solved the problem.. to summarized : all subfolders within the mysql directory->bin, lib, man, mysql- test, etc, etc is owned by user root except for the DATA folder w/c is owned by mysql user.
View Replies !
Server Doesn't Take All Options Out Of My.cnf
------_=_NextPart_001_01C34C58.52CDCBE2 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable My problem is, that all variables except "wait_timeout" are initialized from the my.cnf file, only "wait_timeout" is always set to the standard value... Has anyone the same problem? Does somebody know how to resolve it? =20 Moritz =20 ------_=_NextPart_001_01C34C58.52CDCBE2--
View Replies !
Server-Client
I coded a program by using VB 6.0 I will use this program on network(nearly 12 user). is it necessary to code two different program for both of server and client. Or, Can I solve this problem by MYSQL Control Center.
View Replies !
Fw: Server-Client
I think that I should ask the question like that. I want to run MySQL on 14 client. What am I do. I try but There is a problem that i can't find.
View Replies !
Restart Server?
how do you restart the mysql server? It¹s already running, I just want to stop and restart. I spent 30 minutes searching the manual and couldn¹t figure it out. I eventually just rebooted my server.
View Replies !
|
TRACKER
