Info On Web Hosting
is it my sql that you need to but an ipb (free) becuase i want to knoe how to install my forum as im not quite sure.
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 !
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 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 !
Getting Info
I'm going to select all articles from ~10 databases (on the same server) all with equal table structure. Lets call the db's for db1, db2 etc. And the table for 'article', the condition is that the column 'location' in article is equal to start(eq. WHERE location = 'start').
View Replies !
Db Info
I have just encountered the weirdest thing ever that I have no idea why it is happening. I had a site one 1 server switched it over without changing the db username and password and all the stuff worked on the new server even though the db info was wrong. Is there a way to fix this because I feel like thiscan be a major problem later on.
View Replies !
Looking For Info
I'm doing a University paper on MySQL and haven't been able to find any information on the minimum and recommended hardware requirements needed to run MySQL.
View Replies !
Getting Processlist Info
I have a need to get a list of currently connected users in a query for use in a view. I know the syntax for show processlist, but as of yet I cannot find a way of joining that information in a view. I also can't find any accessible table that lists the currently logged in users. The reason that show processlist isn't sufficient for my needs is that I need to display this information in a vb.net application, which as is currently designed uses one view. I would like to modify the view to include a boolean value based on whether or not they show up in the processlist. I don't care what process they are using, nor do I care about the state of the connection.
View Replies !
MySQL Info?
for a long time I have been using Postgresql as my application target database, and while I'm really pleased with it I miss many proffesional features availables in other databases (say Oracle or DB2), specially those points concerning High Availability, Clustering, monitoring, ... Now that CA has realeased Ingres under opensource I thought it was time to change to such database since Ingres has all the proffesional features one can spect and is a very alive project. I studied time ago to change to MaxDB/SAPDB when it was opensourced and asked in a lot of forums through the internet but what people told me (SAPDB administrators mainly) was discoraging and MaxDB looked to be "dead". My doubt comes now. What about MySQL? Last time I cheked it (ver 3.x) it was far away for suiting my needs (no ACID, no triggers, no clustering, ...) but I have read in the news many things are changing in the upcomming ver 5.0. How much true is that? Can I hope MySQL v5 to be able to compete with Ingres, Oracle or DB2 in features?. - Is it well documented ? (I was asthonised with Ingres that has been opensourced with more than 20 pdfs manuals covering every small detail about administration, development, monitoring, clustering, ... even with documents explaining the C-source and architecture internals). - Any good reasons you can imagine to choose MySQL instead of Ingres to update Postgresql?
View Replies !
Displaying Info
I'm working on my picture section, i was wondering if there is a way to order how things are layed out using mysql. I want something like this PIC 1 PIC 2 PIC 3 PIC 4 PIC 5 PIC 6 Ect ect. Is there a way to do this and what would it be called?
View Replies !
Sales Tax Info
where I can get sales tax info that I can integrate with a MySQL DB to calculate what tax to charge for each shipping location in my ecommerce app?
View Replies !
Info From Mysql
Are there any way to get info from mysql of the fulltext query passed to it?(ex num_optional_words). ex: for the query: 'car apple +store', one would have: num_optional_words = 2 num_compulsory_words = 1
View Replies !
Compatibity Info
Where can I find information on the compatibility of MySQL 5.x? More specifically, is it backward compatible with MySQL 4.1?
View Replies !
Info From 2 Tables
I'm struggling with mysql, I have 2 tables, ones called pmsys and the other is called user. I was reading about aliases so I thought I'd try it, but when I put in the following information it says the ON statement is wrong. This must have really gone over my head because I don't see what is wrong. how to get this right? SELECT t1.id, t1.to_id, t1.from_id, t1.time_sent, t1.subject, t1.message, t1.opened, t1.time_opened, t2.user FROM `pmsys` AS t1, user AS t2 LEFT JOIN user u ON t1.from_id = t1.id WHERE t1.to_id = '1' order by time_sent DESC; I need the info from the pmsys and the username of the person who sent the message by matching their id in the user table to the to_id in the pmsys table.
View Replies !
Info Into Table
I have made this site http://www.tinemuller.dk/folkebiblioteker/ and used mysql and have a lot of columns but what I need help to is "hjemmeside" which at the moment is empty for all the libraries (name). I have now found a excel-file where I have deleted all the columns that I shouldn't use and only left "name" and "hjemmeside" and name is identically with name in the database online. How do I get my database updated with the informations in "hjemmeside" from the excel-file and at the right place in the row of the right "name".
View Replies !
Can I Get Info About What Is In A Resultset?
I have a php class function that builds a query (on a single table) and invokes it to produce a resultset. Another function, would like to discover what is in that resultset so that it can display it nicely (ie appropriate name and widths for columns). I found the the SHOW command is able to give this sort of information for tables, but I could not find a way of getting the same infor for resultset's.
View Replies !
Getting Info From 3 Tables
I have 3 tables with 6 different date fields: - "problems" with creation_date - "funding_requests" with request_date and 3 different approval dates - "purchase_orders" with po_date I would like to select the list of all problem names where at least one of the 6 dates fall within a particular range. Should I: ....
View Replies !
Getting Info From More Than One Table
ok so Ive normalised my database, and all is good, ro repeating data anywhere. Now.....I'm a bit stuck I have an invoices table, a jobs table, and a customers table. invoices ===== invoiceref - integer primary key autoincrement etc jobref - this leads to the job details invtotal - the total for the invoice jobs ==== jobref - integer primary key etc customerid - the customers id number other - misc colums of job details not relevant to this question customers ========= customerid -primarykeyetc custname -customers name other - other fields , address tel etc ok so i need to display invoice details like this Invoice Number Customer Name Job Number Invoice Total Three of the columns are no problem, just select * from invoices But how do i write a query that will look up the job for the invoice, check the customer, and bring me the customers name too? A cheap shot solution would be to have the customerid field on the invoices table too, but then that would not be fully normalized as we already can get that information from the job the invoice is linked to.
View Replies !
Pulling Info In From A Db
I already have a bunch of tables in a database created by someone else, in which there is one table that I manually change the week number each week from 1 to 2 to 3 and so. This database is justed called week_index Now I just made another table called pictures. In this table, I've included a field labeled week, as well as a field indicating where I have placed the picture on my website. What I want to is just be able to change my week_index file from week 1 to week 2, and my sites pictures will automatically change as well.
View Replies !
Selecting Info From Db
I'm making a small game script, and when I get information from my database, how do I do set it up so that it displays first by the level the user got to, and then by the points he achieved?
View Replies !
Choose Info From Two Tables
Code: SELECT last_name, sales_agent, date_added FROM report_1, report_2 WHERE date_added <= '$start_date' AND date_added >= '$end_date' ORDER BY $sortby $sortorder";
View Replies !
Cannot Fetch User Info
I have a strange mysql problem. The ver. i'm using is 3.23. When I connect it with mysql-administrator, & try t fetch the informatin for any of the users, i get an error. I unistalled it using yumex & then reinstalled it & now i cant get the service mysqld to startup. Can anyone plz tell me how to completely remove mysql from the system & then reinstall the 4.1 version of it.I had a lot of trouble doing so & still couldnt find the sol.
View Replies !
Rename Table Info
i have a table that is built like so... id,game,score,genre,system,year,reviewer,console_id 125,'Aztec','','Puzzle','Neo Geo Pocket Color,1998,'',1 i want to make all entries of "Neo Geo Pocket Color" to be "NGPC"... what kind of command could i exacute to do this... i know how to rename a column... but not table info...
View Replies !
Double Table Info
I'm a newbie setting up a PHP-MySQL database and I'm just at the table creation stage. I'm worried because I have two tables that are showing the same info so I wonder if my database is truly normalized... Here are the tables I am worred about... so far: -Instructor- InstructorID iFirstname iLastname iEmail -Student- StudentID sFirstname sLastname sEmail -Instructor_useraccount- Instructor_useraccountID InstructorID iPassword iPriviledge iActivationDate iExpiryDate iLastaccess -Student_useraccount- Student_useraccountID studentID sPassword sPriviledge sActivationDate sExpiryDate sLastaccess I'm wondering if I can one "USERAccount table" and add a foreign key of USERID to both the Student table and the Instruction rather than the way I've done it.
View Replies !
Dynamically Column Info
I just recently started re-creating some of my spreadsheet databases to real database format using mySQL on Linux & OOo as a front-end (sort of... to create the forms for entering data). Everything looks great but I haven't read or been able to figure out how to create dynamic data fields that can keep running calculations of data from other columns in the same table (or better yet in other tables of the same db). For example, I have an expense report database set-up where I enter all of my weekly receipts & I want pre-tax, tax total & grand total columns that can keep running total of all receipts entered & or changed & keep that data in their respective columns. I hope that makes sense, I know I can do this with a select query command & get the totals I want but I can't sem to save them in the database.
View Replies !
Varchar Info Stored As %nn
One small thing that bugs me - when I store data into a varchar column, if the data has a comma or a space, the data is stored with an HTML-looking % sign. For example, a space is stored as %20. I am using the default encoding. I tried ASCII, and it replaced the spaces with plus signs (i.e. "Hello+there"). I have looked in the documentation, especially at the encoding sections, but have not found a way to have MySQL just store the data "as is", using commas as commas and not as escaped characters.
View Replies !
Change Table Info
does enyone know if this is possible in some way without first get the information UPDATE test SET `bbbb`=`aaaa`, `aaaa`=`bbbb` i don't want to select the information first in issue of server load!!
View Replies !
MS Excel Doesn't Return All Info
I have a simple MYSQL database that I use an Excel front end as an input form / query tool. It all works fine except for a simple query. The syntax is: "Select manufacturerID, manufacturer, mfr_address as Address, mfr_phone from tblManufacturer" When I run this in MYSQL, either at command line or using the Query Browser tool, it returns all data. When I run the same SQL within MS Excel, only the manufacturerID and manufacturer fields are returned although all 4 field names are returned. I don't know how to explain this, the table set up is as follows: manufacturerID - Integer, autoinc manufacturer - character(250) mfr_address - character(20) mfr_phone - text
View Replies !
Fetching And Posting Info
I am having some issues using the mysql_numrows function and I am getting this error Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource I have also tried mysql_fetch_row and some otehr functions but get this warning pertaining to it. Is this a server problem? Does my server not hold these resources. It is PHP enabled, and MYSQL.
View Replies !
|
TRACKER
