Rosemond: But I am not an expert in mysql, so am I allowed to offer a small paid job here in the chat?

Pich: Twirl, it depends. but mostly it won’t work. make backups!

Holshovser: Jkavalik: nono man it has to work it can’t be this stupid

Magnotta: Twirl, same version and same config is quite important config more than version probably

Arras: Jkavalik: man i just need to copy a database from another hard drive

Pilkins: Twirl, you cannot just move tables between servers by data files – it is not stupid so it does a lot of things you do not know about

Walterman: Jkavalik: its not tables its a database

Cosby: In phpmyadmin i can do it in 1 minute

Digirolamo: This should be even easier

Hallinger: Twirl, take care what you say

Hanshew: Twirl, myisam or innodb? innodb stores lot of data without innodb_file_per_table set it is even “all” data in ibdata files – for all databases on the server

Chabbez: If anyone is interested in a small paid job pls pm me for further details

Marcelli: Twirl, phpmyadmin has export, mysql has other export tools mysqldump mostly – if you use that you are ok, but you cannot move just one “innodb” database between servers just by moving “raw” files

Buddie: Jkavalik: i have the drive mounted just tell me what to do?

Steibel: Spaceman75, you can try giving some info, prepare a pastie or sqlfiddle.com and maybe you get some hints even for free ;

Mench: I dont feel like restarting my server and booting from the other drive

Zagorac: Which luckily i could do if i needed to

Barthell: Twirl, does the drive contain entire datadir of some mysql server? if yes, retrieve config for it and install/redirect the same mysql version to that datadir and dump what you want

Dible: Jkavalik: retrieve config? install/redirect the same mysql version to that datadir and dump? man that would probably take a lot more time than to just boot from the other drive and export the database

Ventur: Don’t u have a quick and easy way, there has to be one, i have the data right there

Giltner: Is this a security measure or something :

Kostal: Twirl, then reboot and dump, it is the most simple and safe solution if you can

Pistilli: Twirl, no, it is the structure of the data, mysql has not separate databases database is mostly a namespace so there are lot of “global” data and catalogues etc

Keidong: And you do not want to mess those up

Bracher: There are more “efficient” ways of moving data, but I am not sure they would work without the active server – xtrabackup can be better faster than dump, but if you dont have tens of GB then dump is good

Zaro: Nice, this bios from the year 2000 doesn’t even have boot order for multiple hard drives

Gladden: I am trying to use a 3rd party application called Podbox, this syncs data between my Zoho account and my contacts tables in myphpadmin

Kralicek: For some reason the stored procedures are failing

Sneed: And they are beyond my skill level

Wilkosz: So I am happy to pay someone to fix this

Riechers: Jkavalik: okay it worked, ty

Torrance: Whats the best way to reset a database without using the DROP DATABASE command?

Dume: Nuge: what do you mean by reset?

Naquin: Danblack – i’m looking to drop all tables, sprocs, views etc and run a script that re-creates everything enm***e.

Sommese: I want to be able to iterate the script to being correct, on a test-database that can be burned each time

Keney: Yes but painful. drop database is a lot simplier.

Pele: Nuge, you can iterate through information_schema and get that info.

Thibadeau: I was hoping to avoid that if possible

Agins: I want the same effect as a drop database, but don’t want my sciprt to be run against the mysql tables if the create-step of that database were to fail for some reason