Tag Info

New answers tagged

0

You can skip the filecopy step and just insert the data directly to SQL Server. yum install freetds (use EPEL repository) and then use freebcp to insert the data into SQL Server from the linux box.


3

I would like to know if it is possible to share the structure and data between the two systems without duplicating and/or having to copy everything each time I load a new OS. Effectively, I would like all the data to be available to Ubuntu when it is created in Windows, and vice versa. You can't. Just not supported, not possible. No can do. PostgreSQL ...


0

There is actually nothing really wrong here, at least not based on what you have included in the question. Go back to this point: ubuntu-user@ubuntu-vm:~$ mongo MongoDB shell version: 3.0.1 connecting to: test Server has startup warnings: 2015-03-27T12:37:30.430+0100 I CONTROL [initandlisten] 2015-03-27T12:37:30.430+0100 I CONTROL [initandlisten] ** ...


0

If you want to recover by filetype, please note the following structure in MySql database file system: A MySQL table is the combination of three files: The FRM file is the table definition. The MYD file is where the actual data is stored. The MYI file is where the indexes created on the table are stored. Source: [1] ...


0

mysql -u akht -p(akht is my database name) -u is for "user"; -p (without a space after it) is for "password"; a lone word (no -x before it) is the database name. GRANT ALL PRIVILEGES ON dbname.* TO 'fred'@'localhost' IDENTIFIED BY 'password';


0

Have you tried logging in to PHPMyAdmin as root? You should have been asked to give a root password when you installed MySQL. Create a user ("fred") and then give fred privileges to access/manipulate that db - GRANT ALL ON My_database TO fred (or similar (from memory... check the docco). [EDIT] My thanks to my learned friend @RickJames for providing the ...


7

rm -f ibdata1 ib_logfile* Well there's your problem. You deleted your INNODB table space. You'll need to restore from backup. Just curious: where did you get the idea that you should remove those files?


0

You could also use MySQL events (like internal cron) and select into outfile. Advantages of this method? Your backups will contain this logic. Both approaches are valid IMO just depends on your preference.


0

To check this out, I did the following - I created a file called my_script.sql [pol@localhost inst]$ more my_script.sql use test; select * from example; [pol@localhost inst]$ Then ran the following [pol@localhost inst]$ ./bin/mysql -S ./mysql.sock -u root -pdba < my_script.sql > xfile Warning: Using a password on the command line interface can ...


0

After talking to someone more knowledgeable then me I have came up with the following answers to my original questions. TLDR; Cron should be fine for what your doing but don't write a bash script, write a PHP script instead, it's better. Q1. Do I have to worry about putting the database username/password into this >cron script? A1. As long as ...


0

In my case i changed the host ip in /etc/hosts file but there was a hosts.swp file locking that change. So Listener was not coming up with the error "Linux Error: 111: Connection refused" used "vim -r /etc/hosts" to recover the change to the file, corrected it again clearly, then Listener came up


0

If you want to do this for MyISAM or mixed tables without any downtime from locking the tables, you can set up a slave database, and take your snapshots from there. Setting up the slave database, unfortunately, causes some downtime to export the live database, but once it's running, you should be able to lock it's tables, and export using the methods others ...


0

Are you using Putty to log in to DB server or some other server? If its DB server then, error can be caused by following 1) Incorrect username/password 2) Incorrect port number 3) MySQL DB is not up and running If you are trying from different host to connect as in remote DB host make sure 1) you have connectivity between the hosts and 2) there is no IP ...


0

you need to make sure the ownership and privileges are correct for the directory, you can use the following commands to set it right: chown -R mysql:mysql /var/lib/mysql/ --your mysql user may have different name, if its different you need to change it [mysql:mysql] as needed chmod -R 755 /var/lib/mysql/ note: -R: recursive fir the directory and all its ...


1

There is no reasonable way how to do that. For example till 11gR1 SELinux was not certified to be used with Oracle database. Since 11gR2 this is at least not recommended. Let's assume that you and Oracle DBA are adult, where is the problem then? Oracle is not running with root privs. On the other hand Oracle requires many kernel tunables(sysctl) to be set ...


1

TNS Ping does not care about service or SID, all it checks is the availability of the listener, so this does not mean your connection string is correct. Connecting through SQL*Plus successfully however confirms it. Your tnsnames.ora uses SERVICE_NAME in CONNECT_DATA, but your JDBC URL uses the SID syntax. SID and service name are different concepts, and ...


0

SHOW VARIABLES LIKE '%open%'; Probably one of those is too low. At a shell prompt, do ulimit -n That will tell you what the OS is letting you have. In some recent OS builds, it was the ridiculously low value of 1024. If so, increase it to, say, 16000. Then restart mysqld and see if the SHOW increased the values. (Some default values are computed.) ...



Top 50 recent answers are included