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 Complete Forum Thread with Replies
Related Forum Messages:
DB Hosting
I Was looking for a bit of advice, I am new to mySQL and the whole idea of building DB's and websites. There are a few things I would like advice on. If I wanted to put a database that I have made on mySQL onto a webserver how can I do this? Also if I built a website with a db for say a small business would it be a good idea to place the DB on a webserver? I.e. would the db information be safe? Is there a better way to do this?
View Replies !
Hosting MySQL
Any good tutorials on setting up the MySQL server for hosting? is this even possible in the community version?
View Replies !
MySQL Hosting
does anyone know a stand-alone MySQL host... i need to be able to access a MySQL database from anothersite... seperate from the host of the MySQL database...
View Replies !
NySQL Hosting Provider
would be interested in any advice since this is new territory for me -- my experience has only been with Access so far, and for situations where only I could modify the database. But now I have a web application where lots of users need to have password access and be able to modify their own data etc, and where I need to be able to administer the whole thing.
View Replies !
Hosting Service's SQL Command
I have been having trouble getting the following statement to work to populate my databse with data from a text file. LOAD DATA INFILE 'Listings-Residential.txt' INTO TABLE `RESIDENTIAL` According to my hosting company's support, cPanel configures databases in such a way that this statement will not work. My question is, I also have access to a co-worker's hosts - one that runs Plesk and one that runs Verio's control panel. Do either of these panels disallow this statement? Is this a common thing, that control panels configure databases in such a way that certain commands cannot run on them?
View Replies !
Yahoo's GeoCities Pro Hosting
I am using Yahoo's GeoCities Pro Hosting and when I get into "MyPHPadmin" to view my databases I get the following message. Warning: Your privilege table structure seem to be older than this MySQL version! Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem! How can I get to the script?? Can't find it.
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 !
Hosting Photo Album
I am writing a database for an online photo album website which will allow people to sign in, upload photos, and have an online photo album. I am trying to figure out the best design for this type of application, and I am not sure how to best set up each persons picture database. I suppose there can be a table with a list of all of the people, and then a table with all of their information that is linked to the list of people..does that sound right? Also, does a primary key need to be the same for each table that is related to each other? (Silly question, I know.)
View Replies !
Pull Hosting Plans
I am currently creating a web hosting website for a client of mine, for the packages and the order process we are using a script called "Auto-Host (http://www.idevspot.com/AutoHost.php)", which stores all the hosting plans into a mysql database. This is a great script and it does exactly what we want it too, the only thing missing is it doesnt create a page where people can view the hosting plans and click a sign-up button. Can someone please give me guidance on how i can get a page with all the hosting plans on please?, alternatively i am willing to pay somebody for doing this on my behalf
View Replies !
Demon Hosting How To Use It (odbc/MySQL)
My customer wants a PHP web page; very basic one which I can do for him but I have no idea how to set up ODBC connection (I want to use Access format database) on his account. I can do that with fasthosts quite easily but I cannot find anywhere this option on his demon account. p.s. How do I use MySQL with demon? do I need to install anything on my pc to connect to their server?
View Replies !
Client App Connecting To A Hosting Database
I have installed this webapp http://www.webhelpdesk.com/ on my 2 computers. I want to setup both computer to pull data from my hosting database. I'm with dreamhost.com and when I created my database with the name webhelpdesk. When I checked the database its show as webhelpdesk.domain.com. When I try to change the database on the webapp I get the following: Could not connect to MySQL database 'webhelpdesk' on host 'webhelpdesk.domain.com'. Please confirm the connection settings.
View Replies !
How To Control Mysql In Hosting Server
I am a ASP programmer. I use MS Access for quite some time, and I am to switch to MySQL. The way I use Access is create tables in my computer and upload it. When I want to do backup, I will download it and make another copy locally. 1. How to create a MySQL DB and Upload it? 2. How to modify the DB structure? For example, create index for certain field? do I have to download it and change it locally? 2. How to download and make backup?
View Replies !
Odbc Problem While Hosting Mysql In Ubuntu
I am new comer in mysql, i have a code that is running well when i am using vb6 to accessing mysql database which is hosted in windows. But the odbc facing problem ( table "ttt" does'nt exist ) when i am trying to host the mysql database in ubuntu. I have trying to looking for the solution from google, but until the time of writing this thread, i got no solution.
View Replies !
MySQL Version - Hosting Problem/Question
I was wondering if any of you ever had experiences with different MySQL version with your hosting providers? I used MSSQL with PHP last month in a project and I liked the clean and easy code after using STORED PROCEDURES. So, How can I go about using MySQL 5 or so if hosting provider doesn't support it??
View Replies !
Can I Upload A MYSQL Database To My Free Web Hosting Space?
I have a domain with awardspace.com which has php and MYSQL enabled. I am a newbie and not quite sure how to set it all up or if it's even possible with the Database I've created on my desktop. When I go to the Database Manager in the administrator section it has a spot to create a database,and confirm a password. From there I take it you would use the PHPMyAdmin to alter the database. Can I just upload a database using an FTP manager like Dreamweaver, or do I need to start from scratch and create the database on this server. If so is there a way to eventually download it so I don't lose any of the information in it.
View Replies !
How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site. I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database. I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases. For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5 I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92 If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers). The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process. Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?
View Replies !
Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.
View Replies !
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 Replies !
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 !
|
TRACKER
