My question is regarding Microsoft Access Databases and ASP.NET. I know that you need SQL server installed so that your website can communicate with any sql databases in use. Do you need Microsoft Access installed on a server where you accessing a MS Access Database?
View 1 Replies
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases.
The two errors I get are:
Operation must use an updateable query.
or
Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database. (they are not read only!)
Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus.
Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time?
I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right?
If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access.
Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
today we notice that all subscriptions on Plesk when we access phpmyadmin has access to all databases,it was a Plesk update that can be done this ?
I don't remember to update anything during this days to this happen.
I would like to build a personal website powered by a content management system and I'm wondering: How many SQL Server databases a site requires? At the Godaddy.com site, the plans for Windows offer one, two or three SQL databases and at least 10 MySQL databases.
The integration with MySQL is easy?
How can i check (using SSH) which databases/users cause server load to mysql ?
I've tried "mysqladmin proc stat" but it shows just the current. How can i get stats of the last 24 hours for example ?
I've also seen slow connections stats. What is the command to check more detailed report of the slow connections; which databases caused it etc', in the last 24 hours for example as well.
I have upgrade my mysql plesk installation from 5.1 to 5.6 and have troubles in setting utf8mb4 charset for server and databases. Special characters still display badly in my websites. I'm running Windows Server 2012 R2 and plsk 12.
View 1 Replies View RelatedI have Plesk 11.5 (service provider mode) on a Windows 2008 server IIS7.Most of my sites are developed in .asp and therefore i use a custom 500-100.asp error page that check s the IP of the visitor then displays either a friendly error, or if its my IP a full error of what has happened (it also emails me the error). This allows me to debug pages easily whilst developing and to keep an eye on anyone trying SQL Injection hacks on my sites (as the error and email also have session variables and IP address).I dont have root access to the server as it is a Webfusion dedicated server.I have following the Plesk documentation -
1) Switch on custom errors for the subscription
2) Look in virtual directories and navigate to error documents
3) Find the error in question (500:100) and change it to point at either a file or URL
FILE - I had the data centre add in the 500-100.asp error page in to the virtual template so that my page is available in the list of virtual files - this didn't work but that maybe because its not a static page??
URL - when i add the path it says its incorrect, if i add a fully qualified address, it accepts it but it doesn't work.give me a specific example of the URL that can be entered relative to the root as the format in the documentation isn't accepted. The last step is to restart IIS which is also an issue as i cant seem to do this from the Plesk panel..It is as if it isn't catching the 500:100 error, and only catching the general 500 error??
Do u want to run an online e-commerce store? create a forum? or develop the next facebook or myspace? If you answered yes to any of th questions then there are very important factors you need to consider before choosing a host.
You have to understand that there's a difference between Database and database size. UNLIMITED database means that you have as many databases as you want, but of what use is an unlimited database if the disk size for the database is just 50MB for example. Don't be deceived by the number of database a web host company is willing to chun out. Do a little research, ask questions. Afterall you might not need an unlimited database afterall.
So your host keeps at least a daily backup of your database, but if you don't get to the backup in time, you may find that they have a backup of a crashed database. That means its important to have a procedure for getting regular backups by other means too. How are you doing this?
View 9 Replies View Relatedwe have been trying to import sql databases through cpanel.
The old server the client was on did not have any control panel. While the new server the client is migrating to, has cpanel. We try importing sql databases through cpanel, but because the sql databases are so large in size, they corrupt while importing them.
The client's old server he would be able to access all his sql databases through FTP.
While with this new cpanel server, we can't upload sql databases by FTP. We are wanting to use FTP because when using cpanel, the sql databases corrupt.
So is there anyway to upload sql databases with FTP directly into mysql when using cpanel server?
Does anyone know anything about how to set up a mysql database? I installed this script for a gallery for wordpress but it won't create it's own databases. I already set one up myself but Im still getting this error:
Quote:
SELECT * FROM wp_fim_cat ORDER BY date DESC
Is there something Im supposed to add inside each database table? And how do I add it to make it work?
I need to export all databases on my server to put it on my new server. Is there a quick and easy way to do that without doing the WHM transfer?
View 4 Replies View RelatedJust wanted to ask, which folder are the MySQL databases held in for Cpanel? Running CentOS 5 VPS.
View 7 Replies View RelatedRecently I have noticed at least a couple of SQL 2000 databses hacked in different servers. The hacker inserts a javascript code whose source is [url] file. The code is inserted in all records of some tables especially the tables having html code in the records. We are running SQL 2000 on some unused port and not the default port and also we have firewalls enabled in all the servers. We also have the latest updates and fixes applied in the servers. Can anybody throw some light on this and help me find the cause and solution to prevent this from happening again?
View 14 Replies View RelatedI have most of my sites on the very reliable clook.co.uk but I only only get around a Gig of bandwidth per month per site.
I'm thinking of getting an unlimited hosting package so I could upload client's music files, large images, video clips etc.. Nothing is illegal or adult. Then I could host my sites as normal at Clook and then point to all the very large files being hosted at the new place.
I think I'd get about 10Gig of traffic max a month. And as it'll just be an extended online harddrive I've no real need for databases, email, php, cPanel etc...
I've seen some unlimited offers at hostpapa.co.uk for 4.99 a month with a free domain. Is there a catch? What do you recommend?
I am using bqinternet.com to backup (Rsync) some accounts.
I sent them a ticket before 2 days and didn't get any reply.
I used this command to schedule a remote backup for specific accounts:
Code:
echo "30 6 * * * root rsync -avz -e ssh ~account1 ~account2 ~account3 myuser@myuser.bqbackup.comerver" >> /etc/crontab
But, I found this command will backup only files.
How can I backup also databases?
I've recently been asked to do a lot of data extraction from a state that has about 20 databases, each with between 10 and 100 tables. I often find myself diagramming things out on paper to try to visualize how everything works together.
I wondered if there's a tool that would "draw" the tables, columns, and relationships? I hesitate to say this, but almost like how MS Access does it, but that runs on Linux and does MySQL. Is there such a thing? I know about phpMyAdmin and MySQL's Query Browser, but it's not what I'm looking for.
I am running a dedicated server with Debian, and I installed a community sofware that has a lot of mySQL entries, many of which need to be changed to fit my needs
However, it is very hard to know exactly where each value I need to change is stored. Is there a way to search all database tables for a specific value?
For example, one thing that is stored in the database is the site's title displayed in the browser's title bar. The sofware does not give me the option to change it, so I have to find where it is located in the database and change it myself, but it would be extremely time comsuming to check all tables one by one for any occurences of the current title.
My HD was failing. So ServerBeach quickly set me up with a fresh box with the dying drive installed as a secondary drive. (nice job guys)
I'm able to mount the secondary drive and browse/copy the files... but when I get to the most important files of all, the database binaries, my /var/lib dir looks like this:
Code:
[root@rosemary v2]# ls -l /mnt/dying/var/lib/
total 68
...
....
-rw-r--r-- 1 root root 2171 Sep 14 03:02 logrotate.status
drwxrwsr-x 6 root 41 4096 Oct 12 2005 mailman
drwxr-xr-x 2 root root 4096 Oct 12 2005 misc
?--------- ? ? ? ? ? mysql
drwxr-xr-x 4 root root 4096 Oct 12 2005 nfs
drwxr-xr-x 2 ntp ntp 4096 Sep 14 10:31 ntp
...
...
And if I try to cd into the dir, I get this:
Code:
[root@rosemary v2]# cd /mnt/dying/var/lib/mysql
-bash: cd: /mnt/dying/var/lib/mysql: Input/output error
I really *really* need this data!
Am I just totally S.O.L. ?
I host with hostgator and I was wondering if there are any software programs or services, or even something in my cpanel that can automatically grab my MySQL databases and everything on my server and make a backup on my personal PC?
I know I can manually do this, but I would like something that automatically does it once a week or something to insure my clients data is always backed up.
I have several DBs and need to run a cron job on one of the databases every night.
to run a repair/optimize on the DB as its very active, this is the command I thought I would use:
Code:
REPAIR TABLE `etc` , `etc` ,
Code:
OPTIMIZE TABLE `etc` , `etc` ,
How do I specify which database to run this on in the cron in CPanel?
i currently have a database which is about 400mb
I am trying to use lxadmin to do a back up but it keeps crashing the db
how do i do the mysql back up?
i have ssh access
How can I allow only one ip or a list of ip addresses to access port 8443.I need to limit access this port to few ip addresses and not everyone
View 6 Replies View RelatedI've been running a forum for a while now which of course had a database. Now I sold the vBulletin License and I'd like to delete the database that was created for it. How do I do that?
I've looked throught cPanel, but couldn't find an option on deleting a whole database. Might be looking in the wrong sections or something. Can someone help me out?
It would be even better if it is possible to reset my whole server throught cPanel. Is this possible?
Curious to know the maximum number of sql server databases you guys have seen on a single server box?
View 0 Replies View RelatedSome accounts on cpanel were suspended then when reactivated the databases didnt connect for some time.
All sites apart from one came back up but one database was corrupted and had to be restored but now the site isnt connecting to it.
I have a corrupted VPS, and have some mysql databases on it.
I want to backup databases and restore them on the new server.
Cpanel service is down on the vps and I cannot transfer accts.
Is it possible to do so ?
1- Zip or Tar the username folder in /home dir.
2- zip or tar the database name in /var/lib/mysql folder
Either by SSH or File manager trough HyperVM
Then transfer files some where safe...
When vps is rebuilt, restore the archives and databases to
the folders I have backed up before rebuilt.
There are also some accounts on a terminated vps that there is only an image of the vps available so, I only can tar files using a jailed shell account, move to the new vps and untar them.
how to do it and avoid database problems.
