Drupal 6 database schema dump, anyone?

Posted by DurpalNoob on December 3, 2007 at 4:23pm

Hello,

can someone please do a sql dump of the schema and post it here, I tried looking at the system.install page and it looks pretty cryptic hehe.

Thanks in advance!

Comments

Nothing crypic about this.....

Posted by AjK on December 3, 2007 at 9:32pm

mysqldump --no-data YOUR_DATABASE_NAME

pg_dump --schema-only YOUR_DATABASE_NAME

But Drupal 6 has a much better system that I would describe as "cryptic" if you look at the array structure. I would say it's easier once you understand how the arrays are intrepreted.

I don't have an install,

Posted by DurpalNoob on December 3, 2007 at 10:05pm

I don't have an install, that is why I was hoping someone could do a quick dump for me.

I'll have a look at the file again and try and understand the array structure etc. in the meantime!

Hi, I've made a quick mysql

Posted by jvaill on December 5, 2007 at 4:49am

Hi,

I've made a quick mysql schema dump for you : http://pastebin.com/m652c77de , enjoy! :)

- Justin

thanks justin! Much

Posted by DurpalNoob on December 14, 2007 at 11:29pm

thanks justin!

Much appreciated!

The URL is no longer

Posted by EnekoAlonso on February 28, 2009 at 7:27am

The URL is no longer valid.
Why there isn't a public DB schema published somewhere at Drupal.org?

I need the schema of Drupal 6 cache_block table.

Drupal 6.15 Database scheme

Posted by Jochen Wendebaum on January 5, 2010 at 2:06pm

Drupal 6.15 Database scheme. Run install.php after posting this into your db

available as .sql text file here.