Recentrly my servers mysql has updated and now i have problems with my phpbb database. I cannot access some of the tables or back-up them. I did some research and founded that becouse of the update, my old my.cnf has been replaced and lost setiings for innodb. I founded the file, but i don't know how to make it work.
I do not have a back-up of the old my.cnf
I'm trying to install Debian 6.0.1a on a MacBookPro5,5 (intel core 2 duo - EFI firmware). I have rEFIt 0.14 and a live cd of Debian (on a usb stick). I'm installing Debian on a usb stick. The installation process goes along smoothly, but then, it's impossible to boot up the freshly installed system (I get a black screen with a blinking cursor). I read that this is a common problem but all the solutions I have found have not worked for me.
The underlying idea is that since Macs have EFI firmware instead of a BIOS, the partition tables of devices are different (GPT for EFI versus MBR for BIOS), and grub is incompatible with GPT (I know there is an EFI version of grub but it is said to not work well). So the devices must have both a GPT partition table and a MBR one. These have to be "synced".
The tools available for this are:
- rEFIt can sync the partitions, but I haven't managed to have it sync them on any other device than the main hardrive. If I sync the main hardrive, then even the live cd (which is on a usb stick) won't boot (black screen with "GRUB _").
- Debian has a tool called gptsync, which returns a message saying "no data partition in gpt table, nothing to sync".
- Mac OS X has a tool called gptsync which returns a message saying "unknown partition type detected - I'm not touching this disc".
The reason there is no data partition is that gptsync sees my main partition as "EFI system". If I could change that, maybe I could sync the partition tables. Can that be done? Also, something I don't understand is: the live cd boots fine without grub. So why do I need grub? Couldn't the system boot up without it like the live cd does?
I just installed Linux for the first time and then stupidly changed the command of the computer in the computer properties. now I can't get access to the computer directory and I need the computer's command again. I recall it started with Nautilus and I can't remember the following letters/numbers.
what to write under the computer properties so I can get back access to the computer folder?
1) Can I use the LiveCD to access my files stored in Windows? (The attached screenshot shows my Computer.)
2) If so, can I backup the files to DVD using CDDVD Creator, which comes with Ubuntu? If not, what must I do to accomplish these 2 things if I install Ubuntu?
I have a back up hard drive I cannot access. When I try to move folders there I get the message 'access denied'. It is probably a simple permissions problem.I need some help to get permission to access it.
View 7 Replies View RelatedI just upgraded from Suse 10.x to 11.2. Unfortunately, I didn't use 10.2 much and I('m a bit overwhelmed by the upgrade. Any advise is greatly appreciated.
After my upgrade, I lost Internet access. I don't really know my way around too well, but I did try to ping my router, but had no success. (Although I can ping 127.0.0.1).
I'm guessing that this means network access is not configured, although it looks OK to me.
What's a good back up utility with a scheduling feature that can back up to a network hard drive? I'm backing up to an NTFS formatted external that is connected to my router and I would like the files to be backed up individually so they can be browsed by other PCs (Windows & Linux) on my network, as opposed to a disc image or archive like some back up programs.
View 9 Replies View RelatedI'm not sure if this is the right spot for this pst or not, first on this forum. I just removed Fedora Core 4 from my system and installed Debian Sarge with the 2.6 kernel. I'm a newbie. The install seemed to go fine, after it was done I actually logged in and looked around some. I then restarted to check to make sure that my boot process went ok and I could still get to windows. Worked fine. Then I tried to boot back into Debian. It hung. I rebooted and tried again. Hung again in the same spot.
View 1 Replies View RelatedI have 2 routers both with 5 network cards (both different subnets). On both machines I have the following configuration: Eth0 is the internet conection, Eth1 is the conection to the other router and the other network cards are for the subnets.My current Ip tables script allows all the subnets of one router to see each other but not the subnets of the other router.
In the new situation I want not all but specific subnets to see each other (no problem here)The issue is that some of theese subnets are subnets of the other router. For example the subnet of eth2 router1 should be able to connect to eth 3 on router2. This is were eth1 comes in play. My plan was to configure iptables so that in above example eht2 would be forwarded to eth1, which will forward to eth1 on router2.Then the iptables configuration on router2 will forward it to the network card of the correct subnet.
eth2 (router1) -> eth1 (router1)
eth1 (router1) -> eth1 (router2)
eth1 (router2 -> eth3 (router2)
[code]....
I am trying to create a database and tables. Does anyone know a reference website that can help me with this or does anyone know how to do this?
View 3 Replies View RelatedI'm using ArchLinux and I have an IP tables rule that I know works (from my other server), and it's in /etc/iptables/iptables.rules, it's the only rule set in that directory. I run, /etc/rc.d/iptables save, then /etc/rc.d/iptables/restart, but when I do "iptables --list", I get ACCEPTs on INPUT,FORWARD & OUTPUT.
# Generated by iptables-save v1.4.8 on Sat Jan 8 18:42:50 2011
*filter
:INPUT DROP [0:0]
:FORWARD DROP [0:0]
[Code]....
Where the cron tables are stored?
IE crontab -e (or -l)
and
the system one :-
sudo crontab -e (or -l)
I need to retrieve them from a system backup, don't know where to look.
We have one linux machine in the office which happens to be an important firewall. I just know the basics and need to make one changeEssentially it is forward mysql traffic to another internal machine.This is the original rule (forward to 192.20.0.17) which is working
Code:
$IPTABLES -A tcp_packets -p TCP -s 0/0 --dport 3306 -j allowed
$IPTABLES -t nat -A PREROUTING -p TCP -i $INET_IFACE -d $STATIC_IP --dport 3306 -j DNAT -
[code]....
I want to write the shell script which
1)Finds all the databases in mysql
2)create the folder who ever is the creater of that database or owner of that database. I think the databse starts with username_ so i think i have to split the database name to get folders name . How to do that? backs up the databases belonging to that user.
Which distros are known to work with the new GPT partition tables as used with disks over 2TB?
View 5 Replies View RelatedI would like to open some port from IN to OUT pop3,smtp.whenever i tried to add some rules to existing iptables it gives me an error.Applying iptables firewall rules: iptables-restore: line 21 failed
View 7 Replies View RelatedHow to configure IP tables in opensuse?My situation is,1. My network is connected in this way...ISP -> Hub -> Firewall Router -> Switches -> DNS ->LANI need to insert a linux system with iptables configured. I am expecting it that it should be between DNS and LAN. For that I am in search of "How to configure IP tables on opensuse10.3
View 2 Replies View RelatedI have a problem as following: "using iptables to prevent IP spoofing".
View 4 Replies View RelatedHow can I delete all the existing partitions on a HDD?I tried using the following command:/bin/dd if=/dev/urandom of=/dev/sda bs=1M count=10This does delete the partition tables but when I use fdisk to create new partitions, then I format those using mkfs.ntfs then the partitions are not seen by Windows.Is there any other way to remove all existing paritions from a HDD?
View 5 Replies View RelatedKeyboard had problems read article said remove xkb data package. Figured out how to do that in synaptic rebooted no Gnome just linux version of dos. I would like to install Kde or kbe desk top have more than enough ram and disk space. How do I get my gui back?
View 9 Replies View RelatedI've been googling this for a while now, and trying different examples, like:
iptables -A INPUT -s 3.2.1.0 -j DROP
iptables -A INPUT -s 3.2.1.0/24 -j DROP
service iptables restart
[code]....
When I execute the command below, does mysqldump lock all tables while the backup is in process? I want to make sure this is the appropriate type of backup command for MyISAM database.
mysqldump -h myhostname --default-character-set=utf8 -u root --password=mypassword --opt --single-transaction DBname > /root/backup.sql
i have an AP set up and would like to have all requests for a website sent to a specific ip address.. and am trying to get this to work in IP tables
user-->AP-->google.com
no matter what site they try to goto it takes them to [URL] i want to use this to require people to login to my server when they connect to my AP before they can go any further.
I am looking for a scriptable solution for downloading tables that are embedded into webpages. If I wanted to save this table to a csv file what would I need to use. On Winders, I currently have Excel doing the job with a script.[URL]
View 2 Replies View Relatedtranslationables,i.e,camp_generic_transcamp_generic_trans_defcamp_generic_trans_epcthese tables exist in cntr1/cntr1@camABC1I have to copy these tables from here to staging environment.I need to first check if any of the tables exist in staging.If yes,then delete and create new.There are 4 staging env from 5 to 8.I have to pass the staging environment as parameter to ask the user which environment does he want the tables to be copied
View 1 Replies View RelatedI am using Joomla and a script within it. That Script is suppose to copy tables from one DB to another.
Code:
Error(1) [1142] query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`
Error [1142] retrying query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`
localiz_master: name of the DB from which data is suppose to be copied.
jos_users: name of the table form the main DB.
localiz_master: user for the DB.
localhost: host
test_users: name of the table to be created.
We do have phpmyadmin but the user's table is hidden. What SSH command we might run to make localiz_master user have access to all the databases.
We are using RHEL 5.3 version. We would like to create a table and print it in linux.For multilingual support, we have refined ourselves to use unicode supported translator like u2ps, paps or lasiprintIs there any tool to create the table in linux,that it automatically adjusts the cell widht and height based on the entries. Also can it be easily converted into postscript format without losing its format.
View 3 Replies View RelatedI'm running Mysql server. I need to know if is possible to generate an alert (email) when in the database are locked tables.
Is that possible?
Can't single the cause of the error.
mysql> CREATE TABLE Shipment (
-> Shipment_ID INT(10) NOT NULL,
-> Delivery_ID INT(10) NOT NULL,
-> Customer_ID INT(10) NOT NULL,
-> Driver_Employee_ID INT(10) NOT NULL,
-> Consignee VARCHAR(255) NOT NULL,
-> Payment_Method VARCHAR(255) NOT NULL,
-> Payment_Received VARCHAR(1) NOT NULL,
-> CONSTRAINT PRIMARY KEY (`Shipment_ID`)
-> FOREIGN KEY (`Delivery_ID`) REFERENCES `Delivery`(`Delivery_ID`)
-> FOREIGN KEY (`Customer_ID`) REFERENCES `Customer`(`Customer_ID`)
-> FOREIGN KEY (`Driver_Employee_ID`) REFERENCES `Driver`(`Driver_Employee_ID`)
-> )ENGINE=InnoDB DEFAULT CHARSET=latin1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (`Delivery_ID`) REFERENCES `Delivery`(`Delivery_ID`)
FOREIGN KEY (`C' at line 10)
i am trying this query to compare records of two different tables...i m geting this message!! no required out putvalues for these ($jobTitle $industry $stationBase $gender $maritalStatus)are coming from textboxes!here is the code...
PHP Code:
$query = "(SELECT *,
MATCH(industry, gender, maritalStatus , typeofWorkPosition , preferCity) AGAINST ('$
[code]....