1

MySQL Databases - Feature Request

view story
linux-howto

http://forums.cpanel.net – There are two new features I would like to see in the MySQL Database manager. 1. In the Current Databases table -under actions. I would like to be able to copy/download the database 2. Below Create New Database box - I would to have an upload / import database box. I would find these two simple features to be time saving from bouncing out to phpmyadmin. Best Regards, William (HowTos)

Songlist's picture
Submitted by Songlist on 09/23/2012

Stories similar to MySQL Databases - Feature Request

I have MySQL databases. Database A and Database B. Running on Mysql 5.5 and Ubuntu 12.04.

Into Database A i am doing INSERTs, UPDATEs every minute (cron) (The whole database has over 15 millions rows and growing).

I want to synchronize Database B with Database A use it for SELECT queries (for performance).

So I want to know: How can I synchronize new rows with Database B every 4 hours.

MySQL cant find my table? 21 weeks 2 days ago

I reformatted my C drive, reinstall mysql for windows then deleted my 2 log files + ibdata1. I set the data path in my config file and was able to connect to my database. I see all my databases however if i try to select any data i get an error

I remembered I needed to set files per table so i wrote

innodb_file_per_table

I restarted mysqld and I still get an error.

I've got a LAMP server installed onto my machine. On phpMyAdmin, I have information_schema, mysql, phpmyadmin as a list of databases's.

I want to create a database with some lists of names, locations and ages to test with.

i am trying to use PHPmyadmin and have installed WAMP server, along with mySQL and have created some tables and databases using mysql command line... what happens is they do not show on phpmyadmin and neither can my php code access those database (the php code runs on the wamp).

i tried setting password to

root:127.0.0.1 and root:localhost

same password as that as for mysql root.

Normally when we create a backup of our MySQL using Mysqldump it creates a Read Lock on the database, so no changes can be made to the database at that time. It may take from a second to few minutes to take up backup of your database. So, sysadmin either prefer to stop MySQL or issue a READ lock on the MySQL table, so that database remains consistent.

Ubuntu and MySQL ? 13 weeks 20 hours ago

I have ubuntu 12.04 on my server, i need to learn how to use mysql or any other database.

I want to try to make an database that holds variables like -

int myvariable = 0; int [] myvariables = int [32768];

How can i make these variables to be only on database ram, and never on harddisk, is it possible to create a database variables that are on global database ram, free to anyone to use.

I have

MySQL Databases 35 weeks 5 days ago

Hello all again,

How do you guys backup your MySQL databases?

I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the database and that's it?

Any recommend for the tool?

Thanks

I tried to import a MySQL dump into my WHM phpmyadmin tonight and it's caused all of the sites on my server to fail at connecting to their databases, so they're all down.

The databases imported but have no tables in them, it didn't seem to have overwritten any of the existing tables as those all still have their data.

We've got a Virtual Server with full ssh and root access running LAMP on Ubuntu Server.

I've got a small computer in the office running ubuntu that isn't being used for anything. I thought I should use it to make and store (a copy of) our MySQL database backups.