i am using fedora 12i want to bakup my mysql database and extract it in my solaris 10 machine.in my fedora machine i gave
mysqldump (database-name) > bakup.sql
in my solaris machine i gave
mysql (newly created dbname) < bakup.sql
[code]....
My existing MySQL database is running on 11.1. I plan to do a fresh install of 11.3 in order to utilize the trimming feature for SSD drives. How should I install my MySQL database to the new version? Do I perform a backup then restore to the new install? Or can I just save the mysql db files to a cd and somehow attach it to the new install?
View 2 Replies View Relatedhow to set up a mysql database on a local machine?
View 9 Replies View Relatedi have two machines at home running ubuntu linux and windows connected by lan. on ubuntu machine i have mysql installed, how do i go about accessing ubuntu mysql database on my windows machine.
View 2 Replies View RelatedI have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies View RelatedI've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedPam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --
I have a hard drive from a server that had a severe hardware failure. I have it attached via usb to the new server. I need to dump the database from the hard drive to a .sql file and then import the dump into the new server.
/mnt/external_drive/var/lib/mysql/ mysqldump -u root -p database name > backupdatabase.sql
My problem is, I enter in the root password, and it gives me an access denied error. I know this is the root password because that is how I am logged into the server. How can I test the credentials of the database that is located on the external hard drive? And, I've used all the credentials that could open this database (database user and root user) and still no go. If I can never get the password for the database on the external hard drive, what are my options?
i'm new to MySQL and i designed a database using MySQL and PHP recently but dont know how to port it to my host company. How do i save the database on my flash drive then transfer to my host on my website's control panel.
View 1 Replies View RelatedI need to work with MySQL database management Software.
But I don't know how it is install on our computer.
I heard that their is a so many step for this process .
i need to get file from a remote solaris,but i can't telnet or ftp it to directly i have to go via another solaris server ,it goes like this windowsbox-proxyserver-mainserver
View 8 Replies View Relatedi have a linux mechine, in that i want to install solaris throug xen virtualization. (solaris content is in CD) while i am doing this there is an option "local install media" in installation method it was not highlighting so i can't install this. then what can i do now.
View 1 Replies View RelatedI ma facing mount problem with error connection timed out between linux and solaris machine.
when i run mount command
root@rose> mount 10.142.201.104:/view/itb_configuration_712/vobs/ims_it /view/itb_configuration_712/vobs/ims_it/
[code]...
My company's default OS is Windows 7. I convinced my manager so that I could use Fedora 12, since I am mostly familiar with development environment in Fedora. However there are a few things I need in Windows 7, and I want to stop going back and forth in two OS'es in dual boot-up setting.
I've searched online for easy way to use the existing Windows 7 as guest virtual machine. I first tried VMware's Vcenter Converter Standalone in Windows 7, but it failed with some error code, and searching the particular error code didn't turn up any solution. I also tried to use Sun's VirtualBox, but I get segmentation fault error in Fedora. I tried to see if VMware server has a tool, but installation exists with an error, and searching the web for the error code didn't turn up anything either.... I wonder if I am having this much difficulties because I am using x86_64 version of OS'es.
Anyhow, if anyone has done it successfully - using existing Windows 7 as guest virtual machine in x86_64 version of Fedora 12.
What commands can be used to install software such as "phpMyAdmin" to Fedora? As I am setting up Apache in Fedora. How to install "phpMyAdmin" and setup phpMyAdmin, so that I can use internet explorer to manage the phpMyAdmin to configure the MySQL database remotely.
View 2 Replies View RelatedHow do you transfer files on a Linux machine with ftp,sftp and scp disabled onto a remote machine
View 2 Replies View RelatedI had run one script in unix machine and want to copy the results to a windows machineBoth the machines are on different networksIn linux machine trying to do the ftp to the windows machine its giving connection refused. How to chech whether ftp is running on that linux machine or not?Also tried scp and ssh , both are failing
View 6 Replies View RelatedI have a lenny system up and running, my CF-card reader is supported and I can mount a 1GB card. My PC _can_ boot from CF cards, I verified... My Linux resides in sda3 (other partition is XP). How would I transfer the partition to a cf card? I tried using dd if=/dev/sda3 of=/dev/sdb1, but as that doesnt work I have the feeling there's more to do... Maybe install GRUB on the CF-Card? Change some paths after copying?
View 6 Replies View RelatedIm trying to install mysql using yum on my fedora 10 machine . When I run:
[code]...
I have Ubuntu 11.04 installed and running on my laptop and was wondering if there was any way to create an install disc/usb or some other way to install Ubuntu in its current state (including all apps, updates, settings etc.) onto my desktop.
View 6 Replies View RelatedI want to upgrade existing MySQL 5.0.77 version on CentOS 5 Red Hat Linux to MySQL 5.1.x. Is anybody have list of patches or upgrades to upgrade to MySQL 5.1.x?
View 6 Replies View RelatedCan I use the config for my current kernel (the jessie 3.16 one), and use it to build a more recent kernel (3.18)? Do I just copy across the config and try and build with it, or is there some tool that will bring across the existing config but also set up reasonable defaults for any new options in the newer kernel, and any other migrations that might need to be applied?
View 4 Replies View RelatedWhile backing up/restoring bacula clients. We were getting an error regarding database tables' version. The error message is given below.. "Found 10 needs 12".
After Googling, what we found is, we have to update the postgres database for bacula. So now we are in process to update the database via the update_bacula-tables script. We are not sure, if it will solve the problem or not. We have just upgraded bacula 2.4.4 to 5.0.1. Postgres version is upgraded from 8.3 to 8.4. It is Debian 6.0 squeeze.
I have question about embedding existing mysql data to FTP. Let me tell you how the system works. Apache gets the user name and passwords records to the MYSQL and creates a folder per user in server. However users can not access their created folder using FTP client software. So how am I gonna merge the existing user/password data in MYSQL ---> to the FTP user/password. Vsftpd and proftpd installed already, so in whichever you feel more knowledgeable, I can go with that.
View 5 Replies View Relatedi inherited 200 tables in a mysql db from each of the 200 table there are table created on php pages
the information is organized pretty much the same (fields) in each of them, so i dont see the point of having so many different tables
i wanna redesign the db, in 4 tables each of this 200 table have a few essential characteristics, like: table name is (version_country_type), ie: v8_de_pro, v8_de_std, v9_uk_pro the fields are: No, Document_file, Document_path, ISBN, Book_Name, Subtitle, Status, Year_issue, Author
i will need to break the table name, and put each part in the new redesigned 4 tables separate fields...
ill have something like:
id, version, country, type, Document_file, Document_path, ISBN, Book_Name, Subtitle, Status, Year_issue, Author
but i have no idea how to do it i know i cant do it in mysql... so ill need to build up a php script which will need to read every table, and drop it in the new format:
table1 called Main: ID, version
table2 called Cat: ID, IDmain, Country
table3 called Sub: ID, IDmain, IDcat, type
table4 called files: ID, IDmain, IDcat, IDsub, Document_file, Document_path, ISBN, Book_Name, Subtitle, Status, Year_issue, Author
Specifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
View 9 Replies View RelatedI recently installed a portable WAMP server on my usb stick. Really nice, I can do some php programming on my girlfriend's windows7 laptop without installing anything on it.I also have a LAMP environnement on my linux computer.When I plug my usb stick on my linux box, I can easily mount -o bind /usbstick/wwwfolder ~/public_html and work on my php script from there.
But my question is, is there a way I could get the database from my usb stick's MySql server, to run on my linux MySql server? So I can modify data base schema from my Linux workstation, doing some INSERTS in some tables, and then plub my usb stick on the laptop and get my up-to-date database running from the portable environnement?I don't know where / how MySql stores its databases. Basically, I want to "mount" the database from the usb stick in my Linux' installed MySql server, without extracting and importing the data, so there is just ONE database used for BOTH environnement.