Someone here know mysql?

[iwearnosox]

Anyone?

 

[minendo]

I love my pet squirrel.

 

[Zugzwang152]

been trying to learn it as of late, minor successes here and there 😀

 

[Heisenberg]

I've used it enough to know I have no fvcking idea what I'm doing.

 

[MrAwesome]

No, but can I get them digits?

 

[iwearnosox]

Well, my asshat host put a full root lock on a domain that had an errant cronjob, which I understand. They will however not return control even though the job was terminated.

I have a full backup (410mb), where is the mysql data in that and how do I repopulate the db on a new server? They won't let me in to do a straight mysqldump.

F dathorn @ this point.

 

[Tetsuo]

upload the backup, and then import your database into mysql, you should have a.sql file somewhere in that backup

 

[iwearnosox]

Originally posted by: Tetsuo
upload the backup, and then import your database into mysql, you should have a.sql file somewhere in that backup

The file structure and paths do not seem at all similar, that sounds like a real bad idea. What I need to know is what to do with .frm and .myd files in relation to a default mysql install..

 

[iwearnosox]

Where would a user's "mysql" folder, which contains .frm, .myi and .myd files be located by default?

 

[kt]

Why can't you do a SQL level backup instead of a file level backup?

 

[MAME]

serach *.frm, myi, myd

 

[iwearnosox]

Originally posted by: kt
Why can't you do a SQL level backup instead of a file level backup?

Locked by root, I'm trying to get them to do a dump for me..

 

[iwearnosox]

Ok, they will .tar a backup for me, what's the syntax for reversing a mysqldump?

Anyone? 😀

 

[iwearnosox]

mysql database <mysqldumpfile

ok let's see.

 

[kt]

Do you know what OS your webhost is running? If you have the full backup, I would suggest you install your own MySQL server and populate the database with your backup. Then do a SQL dump on your own server so that you can do an import to the new server.

 

[iwearnosox]

Too late< i already tried repopulating. It seemed to work, thanks for the input.

<phew>

 

[kt]

Originally posted by: iwearnosox
mysql database <mysqldumpfile

ok let's see.

No.

mysqlimport database mysqldumpfile.sql

 

[iwearnosox]

mysql database <mysqldumpfile is the same thing really.

 

[sygyzy]

mysqldump -u username -p database_name > dumpfile.sql