Archive for January, 2013

Pilgrimage to the Holy Relics incorruptable body of Saint King Stephan Militun in Cathedral St. Nedelia Sofia, Bulgaria

Friday, January 25th, 2013

Saint Stephan Milutin II Holy King of Serbian with Inoccuptable Body testimony for Truthfulness of Holy Christian faith
 

 

As I've landed in Sofia and I'm staying few days in a friend thus I had the opportunity to take a quick look over one of the oldest cities in Europa. Sofia is known under the ancient name Sredets and is dates back to times before Christ. Yesterday I had a walk near NDK (Национален Дроврец на Културата – National Palace of Culture), nearby I saw a little Church which looks orthodox. I dropped by to pray and light up a candle as I usually do when I see an Orthodox Church building I was not in before. In front of Church I saw a priest which looked pretty much like Orthodox, Church interior looked strange as it contained a mosaic of Christ's face which seemed a bit like Catholic. I spoke a little with the priest asking him if he is priest or monk (in orthodox Church we have priest – who marry and monks who didn't). He said he is a Bishop which puzzled me since it is not very common a Bishop to smoke cigarette in front of a tiny Church building …. Later I understood he is from the so called Schismatic Synod – the so called Alternative Synod which claimed our last Church patriarch Patriarch Maxim is not choosen canonically because he was choosen in communist times) ….. I deeply regretted I had the misfortune to enter a schismatic – heretic Church and quickened to leave. Just on the street from NDK Enormous Building which is one of the most well known places in Sofia center.

NDK Sofia Bulgaria center one of most notable buildings

I saw in the end of the street a huge Orthdox Cathedral and though it is the biggest Orthodox Cathedral in the balkans – st. Alexander Nevski.

Sofia Orthodox Cathedral Church building where saint King Milutin incorruptable body is kept

Now it is good time to write about great God's providence. I very much wanted to venerate st. King Milutin for some time, since the moment I heard his holy relics are kept in my homeland capital Sofia. In Nijmegen where I was going to church in the Serbian Church, I had the opportunity to venerate a little particle of st. Stephen Milutin's holy relics and actually it is from where I heard from a first time for this saint. Many saints in our holy Orthodox church has incorruptable bodies like st. Stephen Milutin but so far I never had the opportunity to see such a great unexplainable by science miracle, where a saints body is preserved incorruptable for 9 centuries!!!! St. Uroš II (Stephan) Milutin Nemanjić who was a ruler of Serbia and one of the biggest contributors and donators of Serbian Church ruled over Serbia for 45 years, over this 45 years he donated a multitude of villages, money provisions, gold and all goods to serbian Church. He had promised to God to build so many churches as his years of rulership will be he stand up to his promise and build 45 Churches over his 45 years of rulership. He was well known for dressing in beggar cloak and going out of his castle to be among poor people and often bring them food, clothes and money. In his rulership his greatest stronghold and hope was the Holy Orthodox Church. st. King Stephan Milutin made a lot of donations for Monastiers including the building of newer and more beautiful Church building and a protection tower in Serbian Monastery in Holy Mount Athos Hilendar. St. Stephan is born in y. 1253 and passed away to Christ in October 29, 1321. Here is a picture someone has taken of st. Stephan Milutin Holy incorruptable body.

saint King Milutin holy incorruptable body relics saint Nedelia Sofia Cathedral

 More complete living of st. Stephan Milutin can be read on Orthodox Wiki here.

The size of St. Nedelya Cathedral is impressive, the whole church is full of beautiful icons. It is keeping also a miracle making icon of the Holy Theotokos Virgin Mary – the well known – Joy of all sorrowful. If you happen to drop by the temple you can find it on the left of the entrance / exit door of the Church. The Holy iconostasis of the Church is all in Gold, the dome of the Church contains most beautiful images of Christ surrounded by Angels the fresco seems quite ancient though I'm not sure from which year it dates back. In the right of the Church entrance door is found the grave of exarch Stephan – the head of the Bulgarian Orthodox Church after the liberation of Bulgaria from Ottoman Turkish 500 years long slavery.
The Church is a functional and Holy Liturgy is served every day also an evening service is done everyday. St. Nedelya Cathedral original building dates back from the ancient 10-th century and is connected to a times, where Slavonic translations of the Holy Bible was still young. Going out of St. Nedelya Church just few meters away is located another Christian Church in glory of St. Petka of the Balkans (The Bulgarian). There was times where holy relics of Saint Petka Bylgarska, holy relics resided in that catacomb ancient Christian church. In st. Petka Church there is a small book where one can write all the miracles that happened of people who prayed for prayed to Christ for their various needs, physical healing etc. Also something that strike me in this little Church was the odor in the air which is typical to smell from holy relics of saints. Just 20 meters away from saint Petka's Ancient Church is located another more ancient Church from the 4th CENTURY in veneration of Saint Martyr George the Glorybringer!
The Rotunda st. George is something must see for anyone that never was in Sofia before and I thank God for being able to pilgrimage on such an early Christian church.
Rotunda_of_St_George_4-th-century-Sofia-city-center-Bulgaria

The story line of Saint George Church is pretty long and the visitor can read it. In short as I read the Church has three layers of icon paintings from 3 different periods of the Church use, the most ancient found one dates back from the 6th century.

dome Rotonda Sveti Georgi 4th century Sofia,Bulgaria city center (Sredets)

The Church was used mainly for baptismals in a long time of its existence. Today there is a Holy Liturgy and evening prayer service daily and Church is fully functional and conducting its original purpose of bringing people to Christ.

Interview with Belarusian president Alexander Lukashenko (The Independent)

Thursday, January 24th, 2013

Many people and most of the Western European countries blame Lukashenko to be dictator, to be stealing the freedom of Belarusians and as a bad and intolerant. It is my own understanding that though Lukashenko's leadership of Belarus might have it is bad sides he is not so bad. His thinking actually is much more Christian than most of important politics of the Western European Union. Belarus is still keeping some of their society models left from communism and even today. It is very interesting interview, unfortunately no english translations so, one has to understand a bunch of Russian to understand what they're speaking about. What is interesting to compare one representative of Slavonic world against one typical person who even though Russian by blood and genetics (the interviewing person Evgeni) is a cultural traitor. The interviewer for the newspaper "The Independent" is obviously dressed, looks and talks like most of western europeans, his questions like every journalist are mostly tricky. I really liked how Lukashenko understands Democracy, as being identified with justice on the first place. Lukashenko saying that today we have no democracy in western countries, because there is no righteousness in ruling and things in country is very right.
Belarusian economy managed to survive through the so called Perestroika. If my homeland Bulgaria had enough smart politicians to lead the country into proper re-structure of our economy to an open economy, Bulgaria would not have been in such a terrible
economic state as it is today ….
 

Lukashenko interview Лукашенко – интервью "The Independent" и "BBC" _ телеве

 

Djigan – Derzi mne za Ruku (Hold me for the hand) – Nice Russian modern disco pop song

Thursday, January 24th, 2013

In Vkotankte (Vk.com) – or the so called Russian Facebook there is a functionality to listen music while putting info on your wall or just chatting with friends. It's very, very handy functionality which facebook lacks. There while listening to some random Russian songs I come across a very, very nice modern disco pop song, I'm sure many others will like it. Too sad people part of western culture knows nothing of what is happening in Russia and this part of the world. There is plenty of nice Russian cultural things and modern songs to listen to.
 

Djigan – Hold me for the hand (Derzi mne za ruku) / Джиган – Держи меня за руку

A flight from Eindhoven, Holland to Sofia, Bulgaria Terminal 1 – Few first impressions

Thursday, January 24th, 2013

Eindhoven Airport Netherlands Holland - Sofia wizzair flight picture

The day before yesterday I flight back from Eindhoven to Sofia Bulgaria. Thanks God I had a safe flight with a low cost ticket bought from Wizzair. I spend the last 4 months in Holland so I had some impressions still from Holland. There was no huge culture-shock after landing but of course there was new impressions as well as I haven't been in Bulgarian shops and among Bulgarians so I felt the culture difference.

In Bulgaria, even from the very beginning of landing and getting out from the Sofia Airport (SA), everything was very, very simple, an ATM few information and hire taxi kiosk desks, arriving passengers standing that's all. I had to wait for a friend (Mitko), to pick me up from airport cause he kindly accepted me to sleep in his apartment like always (for which I'm mostly thankful!). During waiting in Terminal 1 (Sofia Airport has Terminal 1 and Terminal 2 (old and new terminal – and terminal 1 is the old one), there was few things that impressed me. First it was the waiting-room. If compared to Eindhoven's airport Gateway waiting-room and lodge was dirty also it was funny noone take care for green decoration plants with started withering :).

Sofia Airport Terminal 1 passengers arrival
There was a coffee / tea vending machine with a bit of expensive prices for Bulgaria standards (2 lv – 1 euro) – for foreigners it is very cheap. however as the main people stream is Bulgarians I think 2 lv is a bit high, so in my view if they just make it 1 lv much more will buy and hence the company that placed the Vending machine will generate more revenues. In terminal 1, thanks God there was a Toilet, which of course was little dirtier than toilet in Eindhoven (in Bulgaria – it seems investments for hygiene are very cut due to the crisis). It seems a bit idea even though the crisis, that people managing Sofia airport decide to invest money in cleaning, hygiene is essential since it is the first impression for Bulgaria arrivels gets. If Bulgaria has to be a good tourist destination as it is often advertised in many European TVs it is good foreigners leave with good impression. I bring out my laptop in hope to use some internet, but though there was two open Networks one of which Vivacom, I couldn't connect to none of them. Well from one side it is good, because we don't allow open hole for Hackers or abusers to use the internet for bad. Also it is my presonal opinion that not encouraging excessive use of internet is not necessery and destructs real communication between people. I was asked on a few occasions if I need taxi or a cheap bus for 6 lv leading to bus center and I rejected cause I was about to be taken by my dear friend Mitko. The attitude of people in Bulgaria was also evident, not so smiling and happy like western europeans but this is normal, since the economy of Bulgaria is almost unworking and about 23% percent sadly in my home land are jobless and even the working are working for a money enough just for basic survival.

Crossing the Finger (Crossed Fingers) – A good luck sign with Early Christian origin and deep symbology

Monday, January 21st, 2013

 

 

Why we cross the fingers good luck sign evokes Christ blessing and depicts cross with hand fingers

 

 

I had a small Skype chat today with my dear Indian friend of mine Happy. She is now in situation with uncertain outcome, where the Indian government has to approve her mother's application for Visa. As being uncertain she used the classical English saying: "fingers crossed – i cross the fingers". I was curious about the origin of Crossing the Fingers and thought for a second over how Cross-ing the fingers originated and how it visually looks like. It depicts a a X cross shape, also interestingly the X is the first letter of the Greek and Slavonic IC XC depicted on each and every icon of our Savior Jesus Christ. XC – stands for Χριστός (in Greek) and
XP-christ-church-slavonic

 in Slavonic, thus obviously crossing the fingers depicts also first letter of Χριστός – Christ  – Messiah (savior of the World). Having the insight I hurried to explain Happy, why I think people used to be crossing fingers when in situation with uncertain outcome.

Just out of curiosity I searched for Crossed_fingers and found it good explained in Wikipedia. After all, my assumption turned right, crossing the fingers is made not just out of old superstitious as many might thought, It was made on purpose by early times Christians. Crossing the fingers is an external expression of the Internal faith,hope,love and unceasing prayer that early Christians possessed.

Crossing the fingers was very popular in times, when Christians use it as a sign to recognize each other in times of persecution. The reason for crossing the fingers is that it resembles the Sign of the Cross. It is believed even  to this day in the One Holy Apostolic Church the Orthodox Church the sign of the Cross when being made invokes over one the protection and blessing of Christ. Sign of the Cross is being done in prayer in the Church in times of trouble in difficult life time events and when evil is faced. The crossed finger sign was also used as a secret way for Christians to tell each other to assemble for prayer and holy liturgy worship service. There is even symbolism in why people cross fingers with exactly those two fingers with which the gesture is done. In very ancient Church times Christians used to make the sign of the cross over their body using two fingers and not three.

Icon of Saint Paul from Ephesus 4-th century preparing to make the sign of the cross

4th-century icon of St. Paul the Apostle from Ephesus – Wall Painting

The sign of the cross when being depicted on one's body was done with the exact two fingers with which the crossed finger gesture is completed.

crossed fingers sign of the cross resembles the salvation of mankind through the Lord Jesus Christ's crucifix

Today crossing the fingers is a popular "good luck" invocation automatic reaction, most people who do it as not being realized Christian don't know why they do it they just believe it will be a magical mantra like which will give them good outcome of problem or difficult situation. It is little sad that we the modern people who think we know a lot and are smart or educated, didn't know even the basics of what made us the nations we're which in the biggest part was Christian faith kept by our ancestors for centuries.

19 January Epiphany – The Baptism of Christ Church hymn in Russian and Serbian Orthodox Church

Sunday, January 20th, 2013

On 19th of January each year, many of the Orthodox Churches who still follow the Old Church Calendar celebrate one of the 12 most important feasts in Church life.

On this date Russian Orthodox Church Serbs, Ukrainians, Molodovan and the Patriarchate of Jerusalem are celebrating.

In  Bulgarian Orthodox Church, Greek and Romanian, Croatia and other Eastern Orthodox who follow new calendar, The Day of Jordan (The day in which Jesus was baptized in Jordan) is celebrated on 6-th of January on the same date when Russian, Serbs, Ukrains and other Orthodox Churches using old calendar celebrate Nativity of Christ.

The feast of Baptism of Christ is one of the most ancient feasts in Church history.
Here is the Church troparion as sung on (Jordanov den – as we say in Bulgaria – St. John's Day).


 

Epiphany Troparion / Тропарь Крещения (Troparion The Baptism of the Lord Jesus Christ in Russian)


 

Тропарь Крещения Господня (Troparion Kreshtenie Gospodne as sung in city of Luhovic Russia


 


 

Tropar Bogojavljenja – The Lord's Baptism in Serbian Orthodox Church

The Baptism of the Lord Jesus Christ hymn in Arabic

It is interesting fact to know that in Roman Catholic Church and most western countries the feast of Epiphany is known as the feast of Three Magi Kings (The Three Wise man who came to bring expensive gifts to venerate the birth of King of Kings the Lord Jesus Christ). Many of the traditions accepted in Western Countries for Epiphany are very similar to traditions practiced by countries where there is widespread Roman Catholicism influence. I've red about the feast as practiced in various countries in Western Europe and it appears many of the traditions are similar as paradigm to German and Dutch SinterKlaas (Saint Nicolas) feast. It is interesting fact that some of the traditions like the releasing of the Cross in Rivers by the Orthodox Priest and cross take out by the bravest man  in Bulgaria is also practiced in Greece, Serbia, Macedonia, Bosnia and Herzegovina and probably some Orthodox Christian regions of countries belonging to ex-YugoSlavia.

We are 300 million. We are Slavonic! – Нас 300 миллионов! Мы Славяне!!!

Saturday, January 19th, 2013

Some might be puzzled to know about 300 million of inhabitants of the world are Slavonic and speak some kind of Slavonic language. This is almost 6% of the population. Slavonic languages are easy to comprehend. It is curious fact that until 10 years ago about half of the books in the world were in Slavonic or some kind of variation of Slavonic. Russians, Macedonians, Serbians, Slovenians, Czechs, Bulgarians, Belaruse, Croatia, Bosnia & Herzegovina, Ukraine, Slovakia, Monte Negro, Poland, Khazakstan. It plenty of people. Obviously it is most likely that the better integration between nations happens based on cultural and language criterias. As all Slavonics more or less share certain similar cultural heritage (at least more closer between each other than to Western Culture), it is good and logical Slavonic nations to unite and be in economic union.
Today I had the opportunity to be unexpectedly guest in Macedonian family. It was quite interesting to find out the food they eat, the language and the people habits and manners are mostly the same as Bulgarians. It was clear that we're one nation, so we had to act like this. I've been once in Slovenia and I had similar observations, it seems Slovenian language is a mixture of ancient Bulgarian, little latin, Serbian and some Germanic. My observations on meeting with different cultures shows it is much easier to understand each other with other Slavians, than with Western People. Probably it is similar if not the same between French, Belgium, German and Dutch.

If the European Union want to survive therefore obviously it should concentrate on unification of two blocks pretty much like the Roman Empire. Instead of trying to create one united megapolis under the flag of some unreal unrealistic slogans.
 

We are 300 million. We are Slavonic! – Нас 300 миллионов! Мы Славяне!!!

 

Saint Thecla and Saint Isidore of Seville – A Patron Saint of programmers, information freaks and IT nerds

Friday, January 18th, 2013

I learned a very curious fact. We have two Christian saints St. Thekla and St. Isidore of Seville which are protectors of Computing and people involved with computational sciences programming and IT related jobs. 
The two saints both lived before the Great Church Schism thus the saints are celebrated and venerated nowadays in Roman Catholic Church and Eastern Orthodox Churches all around the Christian world.

The Holy living of Saint Thecla – The ProtoMartyr (The first Christian woman martyr)

St Thekla saint protecting all IT people and people who work with computers

The reason why Saint Thecla is considered a protector of all people who heavily work with computers and possibly hackers 🙂 is her name, Tecla means "Key" (a keyboard one) in Spanish.
Besides that everyone knows Keys (Passwords) and codes – a sort of keys as well as keys in programming arrays are widely used in Informatics and are essential part of computer basic Software.

Saint Thecla's living is mostly interesting, below is a short story of her earthly live as recognized in Orthodox Christian tradition;

Saint Thecla is considered a direct pupil of Saint Apostle Paul as she turned to be preacher of Christianity after speaking saint Apostle Paul. She lived in 30 A.D. until 1-st century after Christ. St. Thecla was virgin and decided not to mary even though she had fiancee in moment where she heard the Gospel of Christ.

She was miraculously saved from being burned at a stake by the onset of a storm, and traveled with Paul to Pisiduan Antioch. There a nobleman named Alexander desired Thecla and attempted to take her by force. Thecla fought him off, assaulting him in the process, and was put on trial for assaulting a nobleman. She was sentenced to be eaten by wild beasts (a common punishment for Christians in 1st century). Again saved by a series of miracles when the female beasts protected her against her male aggressors.

She sought out St. Paul and his companions, including St. Barnabas, who were hiding in a cave near the city. She spread the gospel of Christ with them in Antioch, and throughout her life performed many miraculous feats and suffered many tortures to give glory to God. Having retired to a desolate region of Isaurian Seleucia with the blessing of St. Paul, Thekla continued to preach God's word and heal st. Paul's spiritual children.

She lived to venerable old age of 90. Even in this old age envious pagan sorcerors come with the intention to defile the holy virgin. .  A large rock split open when St. Thekla called on Christ the Savior to help her, and the rock covered her, and she offered up her soul to the Lord.

St. Thecla is highly venerated by Nuns an interesting fact is during tonsure of nuns in the Orthodox Church, her prayerful intercession for the tonsured nun is invoked.
 

Saint Thekla Protomartyr first christian woman martyr and protector of computer related professions and nerds

The Kontaktion and Troparion as sung in the Church on her day feast in Orthodox Church – September 24 is;
 

Hymns Troparion (Tone 4) [2] You were enlightened by the words of Paul, O Bride of God, Thekla, And your faith was confirmed by Peter, O Chosen One of God. You became the first sufferer and martyr among women, By entering into the flames as into a place of gladness. For when you accepted the Cross of Christ, The demonic powers were frightened away. O all-praised One, intercede before Christ God that our souls may be saved. Kontakion (Tone 8) O glorious Thekla, virginity was your splendor, The crown of martyrdom your adornment and the faith you trust! You turned a burning fire into refreshing dew, And with your prayers appeased pagan fury, O First Woman Martyr!

Saint Tecla is very important woman saint, there is a whole monastery dedicated to her – Saint Tecla Monastery in Ma'loula

 

Saint Isidore of Seville – St Isidore  Archbishop of Seville – An important Christian Saint writer from 6th century

St Isidore of Seville patron saint of System administrators, database programmers and IT experts



St Isidore lived (circa 560-636), he served as Archbishop of Seville. Apart from his great holiness in modern terms, he can be defined as "information freak" and even in modern terms Nerd 🙂 Even in his living he was recognized as miracle worker. St. Seville just like me and most IT people had a hobby of knowing as much as possible, he collected texts and write books on scientific or quasi-scientific facts and theories on subjects from Scripture, Church order, materials, and jurisprudence and medicine to achritecture, agriculture, botany,  food, drink furniture,war, navigation ! etc. etc. 🙂
His books are among the first attempts to create universal catalog of available information in the World. His writtings are a sort of ancient Wikipedia. Even to this age his books provide us with many information and instruction on Church dogmatics and life as understood from a Christian view.

Saint Isidore's most notable work is Etymologiae – which is among the first encyclopedias worldwide – a huge compilation of 448 chapters in 20 volumes.
Contrary to many critics of Christian faith claiming that the Holy Fathers or the Church teach the earth is square shaped and one can reach the end of the world in St. Isidore's work, it is clearly explained that the earth has a circle like form.
 

Diagrammatic world map 12th century as described by st Isidore of Seville the world is round!!!!

Saint Isidore was contemporary to Saint Maxim the Confessor and one of the last ancient Christian Philopsophers, and last of the Great Western Church Holy fathers
According to some sources, saint Isidore is said to be the most learned man of his age. His works played key role on development of Middle-ages educational life. It is curious fact that in year 2000, the Vatican proclaimed Saint Isidore as patron saint of the Internet.
In Orthodox Church, we're not the authority of the Vatican Pope, so for us Orthodox Saint Isidore is not patron saint of Internet, however his contribution for increase of worldly knowledge as we know it today is un-questinable. His Holy relics are currently held in Roman Catholic Cathedral in Murcia (Spain), so any Orthodox Christian who is in deep involvement IT who travels to their or happen to live their might drop by to venerate the saint.
 

saint Isidore of Seville creator of first Christian and knowledge encyclopedia

St. Isidore's episcopate was during a time of disintegration and transition as the ancient institutions and knowledge of the Roman Empire were disappearing. During these times, he set himself to the task of joining into a homogeneous nation the many peoples who made up the Gothic kingdom. To accomplish this task he used all the resources of religion and education available to him. He presided over the Second Council of Seville in November 619, leading to the setting forth of the nature of Christ in the Acts of the council, as he pushed for the eradication of Arianism.

saint Isidore of Seville Christian enlightener of Spain evident Christian 6th century writer - important Archibishop played key role for unification of the Goths nations

A  list of all his works, most of which are unfortunately present on the Internet only in Latin are:

  • Historia de regibus Gothorum, Vandalorum et Suevorum (a history of the Gothic, Vandal and Suebi kings)
  • Chronica Majora (a universal history)
  • De differentiis verborum, which amounts to brief theological treatise on the doctrine of the Trinity, the nature of Christ, of Paradise, angels, and men.
  • On the Nature of Things (a book of astronomy and natural history dedicated to the Visigothic king Sisebut)
  • Questions on the Old Testament.
  • a mystical treatise on the allegorical meanings of numbers
  • a number of brief letters
  • Sententiae libri tres Codex Sang. 228; 9th century
  • De viris illustribus
  • De ecclesiasticis officiis

Sofia Bulgaria one of the Most Ancient cities in Central Europe – the History of Europe

Friday, January 18th, 2013

Many Bulgarians might be striken to find out, today's territory of Bulgaria and on the balkans is in practice one of the ancient inhabitant territories in Europe. Sofia or Serdika, Sredets as the old name of Sofia used to be part of Roman Empire (Byzantine Empire), then of pre-Christian Bulgaria, after Christianization of Bulgaria part of the Bulgarian Empire and then after the fall of Bulgaria under turkish yoke part of Ottoman's Turkish Empire. Maybe surprisingly for many Western Europeans the city of Sofia, happened to be one of the ancient cities important for Christianity as it had a Bishop standing and a strong Christian community since 3rd century A.D. Even until today Sofia has kept its city design which is made in a Roman fashion. Hope this little video unusually made by British will shed up some light to people interested in Ancient Christian history. Enjoy 🙂

 

Sofia Bulgaria, one of the most ancient cities in Europe – the History of Europe

How to move only database and tables structure from MySQL server to another – Dump only empty SQL Schema table structure

Thursday, January 17th, 2013

 

mysql sql dump empty database and tables re-create only SQL structure from one host to another Linux

For web development purposes it is necessery to copy MySQL SQL database schema structure without copying the filled in data. A typical case where a replicate of SQL server structure is needed to be installed on another server is on whether a client is bying a new website and it is planned his website Database Design is similar or same like another already working productive website.

Thanksfully, one doesn't have to script in perl or bash cause  mysqldump dump tool has already integrated option for that (–no-data).

Here what mysqldump man page says of  –no-data;

 

  –no-data, -d

           Do not write any table row information (that is, do not dump table contents). This is useful if you want to dump only the
           CREATE TABLE statement for the table (for example, to create an empty copy of the table by loading the dump file).

 

1. Moving SQL data scheme for all databases in MySQL Server

 On host with SQL containing productive data, to dump only the structure of databases / tables and table type, fields rows etc.:

host1# mysqldump -d -h localhost -u root -p'your_password' >sql-all-dbs-tables-empty-structure.sql

Then on the secondary MySQL server, where empty SQL structure (without any filled in info) is needed run:

host2# mysql -u root -p'your_password' < sql-all-dbs-tables-empty-structure.sql

 

2. Moving SQL data structure for only concrete database

On Linux host1 shell issue;

host1# mysqldump -d -h localhost -u root -p'your_password'  database_name>sql-database-empty-structure.sql

On host2 server type;
host2# mysql -u root -p'your_password' < sql-database-empty-structure.sql

3. Moving SQL data structure for few databases

Lets say you have a user (new_user), who has privileges over a number of databases and you want to dump a dump copy of those empty databases;
Same like with one table, just include names of all databases scheme to dump;

host1# mysqldump -d -h localhost -u new_user -p'your_password'  database_name atabase_name2 database_whatever >sql-only-some-databases-structure.sql
 

Then to import on host2 again;

host2# mysql -u new_user -p'your_password' < sql-only-some-databases-structure.sql

4. Dumping and copying only database names from one MySQL to another

Though the case might be rary you might need to dump and copy only list of all databases existing without recreating table database sub-structure. This is doable like so:

On SQL node host1 run;

host1# for i in $(echo "show databases;" | mysql -u root -p|grep -v -E 'Database$' |grep -v information_schema); do echo $i >> structure.txt; done

host2# for i in $(cat structure.txt); do echo "create database $i;" | mysql -u root -p; done

Though I've tested all this and it is safe to use, if you're re-creating SQL database / tables structure make sure you have a working copy of data from SQL.
Well that's it hope this little article helps someone 🙂