The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
83 views

Phpmyadmin table disappears, but website reads it perfectly

When I log into phpmyadmin, it only shows the information_schema. I have only one table that has been showing perfectly, but one day it decided not to show up. My website reads all the information in ...
2
votes
1answer
67 views

Problems creating a functioning table

This is a pretty simple SQL query I would assume, but I'm having problems getting it to work. if (object_id('#InfoTable')is not null) Begin Drop Table #InfoTable End create table #InfoTable ...
1
vote
1answer
133 views

How do i get iptables to allow me access to my webmin server

Just set up a webmin server using centos but when i type it into the address bar to access it i get Unable to connect how do i configure IP tables to allow me access from anywhere?
0
votes
1answer
446 views

Is there any maximum number of tables for Postgresql in one database

Is there a limit on number of tables which can be created in a Postgresql database?
2
votes
2answers
1k views

How can I change my mysql user that has all privileges on a database to only have select privileges on one specific table?

I gave my mysql user the "GRANT ALL PRIVILEGES ON database_name.* to my_user@localhost" treatment. Now I would like to be more granular, starting with lowering privileges on a specific table. I am ...
0
votes
1answer
249 views

I need some MySQL lookup table advice

I have a MySQL database with about 200 tables. 50 of these are small 2-field 'id-data' lookup tables. Several of these DB's are hosted on a shared server. I have been informed that I need to reduce ...
0
votes
2answers
64 views

mysql mass table storage

We are creating a table to store reponses from customers marketing campaigns, each campaign can generate circa 5k records. With a fast growing customer base we are concerned this table will become ...
1
vote
1answer
409 views

Creating Routes using the second NIC in the box

OS: Linux I need some advice on how to set up the routing table. I have a box with two physical NIC cards eth0 & eth1 with two associated IPs IP1 & IP2 (both of the same subnet). I need to ...
1
vote
6answers
65 views

SQL Server 2000 tables

We currently have an SQL Server 2000 database with one table containing data for multiple users. The data is keyed by memberid which is an integer field. The table has a clustered index on memberid. ...
4
votes
6answers
15k views

How to undo DROP Table?

I accidentally dropped all tables. Can I restore back? I don't have the backup copy.