Browsing articles tagged with "database - 2/47 - Admins Goodies"
Jul 22, 2012
tom

How I can upload an oracle ddl file of 15M

I have a file of 15 mb and i need run the sql of that file in oracle, but when I try load the file, I have a error: The file exceeds the maxim limit When I can change that limit or how I can run that sql file? Asked by diegueus9 Don’t use Oracle Enterprise Manager for this. Use SQL Developer, sqlplus or another tool. Answered by Colin Pickard Check more discussion of this […]

Continue Reading »
Jun 14, 2012
tom

Exchange 2007 Standard – database size limit reached – what can I do?

My understanding is that the 250GB limit in SP1 is just a soft limit, correct? If I follow this article: http://technet.microsoft.com/en-us/library/bb232092.aspx and set the database to 260GB will that work to give me a little bit of time to work with Microsoft on this? I don’t really have any free space left on this logical drive (about 12GB). I also heard that I could move the catalogdata folder (indexing folder?) off this drive to help […]

Continue Reading »
May 29, 2012
tom

What database server will benefit from 4 CPUs

I use MySQL server on Debian GNU/Linux machine with 4 CPUs (Linode 4096) and there are performace issue on havy load (in the middle of the day) but machine is not overload only queries are slow. What other database I can use that will use those 4 CPUs? I read that MySQL use only one. Is there SQL dababse or do I need to use NoSQL? Most queries are selects. Asked by jcubic You are […]

Continue Reading »
May 25, 2012
tom

MySQL permits passwordless logins, wont let me run anything

I was attempting to allow remote logins to MySQL, so i changed /etc/mysql/my.cnf to bind to 0.0.0.0 instead of 127.0.0.1 (I was gonna put it right back, I promise!), but it didn’t work so I attempted to change user root’s host to * (which i later realized should have been %). Anyway, I’m now unable to login to the MySQL server even locally, unless I try to log in without a password, in which case […]

Continue Reading »
May 21, 2012
tom

raid with replication

We are planning to buy two servers which will going to host an SQL database(PostgreSQL). The second server will work as a live replication of the first database server (hot standby). The question I’m having is about the RAID level to chose for the servers. Initially I was planning to use RAID 10 on both servers from performance point of view, but since we plan to store 20-30Tb of data during 5 years, RAID 10 […]

Continue Reading »
May 20, 2012
tom

Want to establish what MySQL DBs are “old”

I want to put some (minimal) logging on our MySQL server, with the aim of determining which DBs on the server aren’t being regularly accessed. We intend to log for approximately a month, and any DBs which aren’t accessed by clients over this time we want to archive. Could someone please point me in the right direction regarding this – most of the logging tutorials I found on the web were concerned with logging actual […]

Continue Reading »
May 17, 2012
tom

using NAS Server as MySQL DB server?

we are small web develepment company with 4-5 workstations. We use one of the PCs as a webserver and DB server. We are considering option to buy some NAS server (like http://www.synology.com/products/product.php?product_name=DS212j&lang=enu) to use it as DB and webserver. As i dont have any expirince in this field, i would ask is this wise? will this cope with the complex and more dempanding sql queries as we test projects on the local environment? Or maybe […]

Continue Reading »
May 15, 2012
tom

Create dump of database schema remotely

I have a connection to remote Mysql database. (i’m using MySQL Workbench). I’d like to copy whole structure of the database, (without data) to create identical structure on my local machine. Is it possible if I have only username and password to access that database? Asked by pnkpnd mysqldump -h <host/ip> -u <user> -p<password> <database> > export.sql Note that there is no space between -p and the first character of the password. Answered by leepfrog […]

Continue Reading »
May 3, 2012
tom

How to setup a mail proxy which logs all emails to a database?

I’d like to setup a POP/SMTP proxy which logs all emails to a database. Nginx does support POP3 and SMTP but I didn’t find any possibility to log the mails to a database. Unfortunately the existing mail server (Postfix) can not be configured or changed in anyway. The server accepts direct connections from/to the internet. In addition there are different mail clients used (Outlook, Thunderbird, iOS Mail, …). Which proxy server is able to accomplish […]

Continue Reading »
Apr 29, 2012
tom

Not all the table in mysql show in phpadmin

I recently accidently dropped my whole database for WordPress, but luckily I’ve backed with Time Machine. The problem now is when I copy the database file back to the path where I store all the database now only 11 out of 28 table show in PhPAdmin I don’t know why. Even I’ve double check the permission group and permission everything exactly the same like other database, but still I can only see 11 of them. […]

Continue Reading »
Pages:«1234567...47»