Mislim da je najlaksi nacin sledeci:

mysqldump --databases tvojabaza >baza.dump

Ovo gore ce ti kompletnu bazu (sa sve tabelama i podacima) sa imenom "tvojabaza" iskopirati u tekstualni DUMP file, koji posle kad prebacis na win ubacis u mysql na sledeci nacin:

mysql <baza.dump

(podrazumeva se da je fajl baza.dump u istom dir-u tj. /mysql/bin)

Jos jedna varijanta:

phpMyAdmin, knikni na bazu, imas dole ispod liste tabela i query textarea, dump database. Pritisni structure and data strikiraj complete inserts(mozes da strikiras i send prije nego sto pritisnes GO da sacuvas fajl da se ne bi mucio da ga copy/paste), na kraju pritisni Go. Kopiraj taj kompletan kod u neki tekst fajl...
Pod WIN-om, startuj phpMyAdmin, naravi novu bazu, posto si je kreirao, imas mogucnost da ukucas SQL query ili da importujes tekst fajl. Pritisni browse, pokazi na fajl i na kraju GO.

Greetz~

hm, ja sam do sada puno puta prebacivao mysql fajlove sa win-a na linux i nisam imao nikada probleme. Gledaj samo da ti verzije mysql-a na obe platforme budu bliske i da su ti tipovi tabela podrzani.

U vezi je sa temom: Moze li neko u par recenica da mi objasni cemu sluzi PHP MY admin, da li je deo MySQL ili PHP paketa, i gde se moze nabaviti? Do sada se nisam susreo sa ovim programom a vidim da je dosta koristan!

To je php scripta, nevezana za php i mysql distribucije, i olakšava neke delove administracije mysql servera i održavanja baza, jer se sve radi preko finog web interface-a.

Kucaj u google phpmyadmin i pritisni ono "feeling lucky.." :)

Ok, naći ću. Uzgred, baš mi je to i trebalo - da olakša posao.

hvala na savetu


sacu da probam ovo cudo sa php-om

pozdrav svima

... samo shto ovo nije dovoljno.
Mora da se naznachi u koju bazu hocesh da ubacish taj dump fajl.
Znachi komanda bi trebalo ovako neshto da izgleda:

mysql baza < baza.dump

i normalno ta baza (u ovom sluchaju sa imenom "baza") mora vec da je kreirana.

Napravi DUMP baze pod Linux-om kao sto ti ljudi rekose (mysqldump) i onda u windows-u mozes bez problema da tu istu bazu ubacis, ma kolika ona bila.

Leka

Neeee, kad otkucaš:

mysqldump --DATABASES imebaze

...onda on na početku kreira i bazu i sve tabele (ali sa IF NOT EXISTS), koliko mi se čini?


Life is bitch=Život je plaža!


[Ovu poruku je menjao mika dana 07-20-2001 u 07:28 AM GMT]

Pa izgleda da si u pravu, samo nekad ne moze tako da funkcionishe.
Npr ovaj ludi emperor je exportovao bazu pod linuxom i ja nisam nikako mogao da je ubacim u win dok nisam prvo kreirao bazu sa istim imenom, a i posle toga sam morao da je ubacujem sa "mysql baza < baza.dump" ... ne znam shta je on radio i kako je on to exportovao, ali to je bio jedini nachin da se baza ubaci.
...dok npr jednu drugu bazu sam sasvim normalno ubacio sa "mysql < baza.dump".

A sta je to MYSQL baza ?

http://www.google.com/search?q=define:+mysql

..
MySQL is a relational database management system, which means it stores data in separate tables rather than putting all the data in one big area. This adds flexibility, as well as speed. The SQL part of MySQL stands for "Structured Query Language," which is the most common language used to access databases. The MySQL database server is the most popular open source database in the world. It is extremely fast and easy to customize, due to its architecture. Extensive reuse of code within the software, along with a minimalist approach to producing features with lots of functionality, gives MySQL unmatched speed, compactness, stability, and ease of deployment. Their unique separation of the core server from the storage engine makes it possible to run with very strict control, or with ultra fast disk access, whichever is more appropriate for the situation.
www.monstercommerce.com/shoppi...y/shopping_cart_glossary_m.asp

A simple, yet powerful, Open Source Software relational database management system which uses a subset of ANSI SQL (Structured Query Language). For more details, see mysql.com.
www.freewebsiteproviders.com/glossary.htm

An open source relational database management system that uses Structured Query Language (SQL).
www.webhosting.net/25.html

Open source database software. Mostly for Unix and Linux platforms.
www.w3schools.com/site/site_glossary.asp

An Open Source development of the SQL language for talking to databases. Most commonly used amongst small business users and run on Linux operating systems.
www.mantex.co.uk/samples/glo-3.htm

An open source database management system for relational databases. A relational database stores information in tables and the information is accessed through SQL (Structured Query Language). See Also: SQL
www.interkan.net/Support/Misc/glossary2.shtm